IBTable - user defined select statement
lazarus / 16-Databases

----------------------------------------------------------------------
Nicole · 2023-03-22 14:35

Can I use a user-defined SQL statement to fill a IBTable?
If yes: What is the name of this propery?

----------------------------------------------------------------------
Zvoni · 2023-03-22 15:12

What is a "user defined SQL-Statement"?!?!?!
Allow the user to "formulate" an SQL-Statement???

----------------------------------------------------------------------
Nicole · 2023-03-22 15:26

I correct myself: define the SQL-statement at runtime by code.

----------------------------------------------------------------------
dogriz · 2023-03-22 15:36

For custom SQL statements you should use IBQuery or IBDataSet.

----------------------------------------------------------------------
korba812 · 2023-03-22 15:57

IIRC TIBQuery, TIBTable and TIBUpdateSQL were created to maintain some
compatibility when porting code from BDE. I recommend using TIBDataSet
because you have more control over the DataSet, including your own SQL
for insert, update, delete, generators, etc...