Falcon1
Apr 17 2008, 02:27 AM
When do I use DataSets, SQL and Query in interbase.
I have managed to get pass many of the teething problems but one that still remains unresolved is the issue of what to when?
Fishfly
Apr 17 2008, 07:25 AM
eh?
well if interbase is similar to SQL server/access/mysql etc then I guess this is most likely how you should work with them....
SQL is comprises of SQL statements such as SELECT, INSERT, DELETE statements etc.
You would create a Query that consists of SQL statements.
A data set (or dataset) is a collection of data, usually presented in tabular form. Each column represents a particular variable. Each row corresponds to a given member of the data set in question. It lists values for each of the variables, such as height and weight of an object or values of random numbers. The data set may comprise data for one or more members, corresponding to the number of rows.