Lazarus

Programming => Databases => Topic started by: Nicole on March 22, 2023, 03:35:20 pm

Title: IBTable - user defined select statement
Post by: Nicole on March 22, 2023, 03:35:20 pm

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

Title: Re: IBTable - user defined select statement
Post by: Zvoni on March 22, 2023, 04:12:09 pm

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

Title: Re: IBTable - user defined select statement
Post by: Nicole on March 22, 2023, 04:26:49 pm

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

Title: Re: IBTable - user defined select statement
Post by: dogriz on March 22, 2023, 04:36:26 pm

For custom SQL statements you should use IBQuery or IBDataSet.

Title: Re: IBTable - user defined select statement
Post by: korba812 on March 22, 2023, 04:57:30 pm

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...