Board index » delphi » Suggest about TIBQuery/TIBDataSet/TIBSQL

Suggest about TIBQuery/TIBDataSet/TIBSQL

I always use TIBQuery for averything it's possible.
TIBQuery and TIBDataSet can be connected to data aware controls.
TIBSQL Executes a SQL with minimal overhead.

Suggest:
1.- Master table scrollable: - - - - >?
2.- Detail table (1-10 records at a time) - - - - >?
3.- Catalog (~300 records) scrollable - - - - ->?
4.- Catalog one record at a time - - - - - - - - ->?
5.- Master table one record at a time - - - - - ->?
6.- For Looup fields only (fields editor)- - - - ->?
7.- To fill a DBlookupCombo (~300 records but 3 fields)- - ->?

Is it worthy to replace IBQueries by IBSQL or IBDataset?

Juan Jose.

 

Re:Suggest about TIBQuery/TIBDataSet/TIBSQL


Quote
Juan Jose Ochoa wrote:

> Is it worthy to replace IBQueries by IBSQL or IBDataset?

        In the cases you give, I wouldn't bother, unless you need something
TIBQuery can't handle, like 64-bit integer params.

        HTH,

        -Craig

--
Craig Stuntz (TeamB)       Senior Developer, Vertex Systems Corp.
Delphi/InterBase weblog:   http://delphi.weblogs.com
Use Borland servers; posts via others are not seen by TeamB.
For more info, see http://www.borland.com/newsgroups/genl_faqs.html

Other Threads