RE: How to work with SQL in a big application ?? Help !

[jr gonzales <jr.gonzales@NSTOR.COM>]

	Nico,

		I'm working on something very similar, My suggestions is
this: Execute your Queries on demand, for example use only 1 TQuery and
one datamodule to handle the execution of the queries. if you need to
run them simultaneaously, then you may need to create a new instance of
the TQuery at run time then execute the query, process your data and
then delete the TQuery class. I use this technique and is working fairly
nice and is easy to implement.

	          By on demand I mean, Creating SQL statement at run
time and then Execute your query or load the SQL stements in a String
list pick the one that you need and then execute, Loading the files into
an string list using the LoadingFromFile Method is very quick so I do
not think that you will have performance problem with this;However you
can expect performance issues with your queries execution depending upon
complexity and type of query. I'm using the String List Approch.
	         


	Enjoy !!

	J.R.

	Note: if your application is a 2-tier client server App. you may
		consider writting a 3-tier C/S and put in the middle
		tier a COM/DCOM object that acts as a SQL broker. This
		can be done very nicely with the BCB 3.0 ( this is what
		I'm using !!!!).