Posting to an SQLTable using Delphi 6 and Interbase 6.

[delphiman]

I am familiar with doing the following with a TQuery using Delphi 6.

if dtsTRNSFR.state in dsEditModes then
else
qryTRNSFR.edit; // qryTRNSFR being a TQuery.
qryTRNSFRC_NO.value := qryCHILDC_NO.value;

Now I am using Interbase and want to do the same thing in a
SQL DataBase called PCHILD.gdb in which I have two tables called
CHILD and TRNSFR. Both of which also contain a field C_NO as
above.

But I am using a IBDataSet (because this obviates the use of IBQuery
and IBUpdate since IBdataSet combines their functions) and there is
therefore no TQuery (as above) involved.

What do I do .. anyone?

 

[Svanhooft]

hi,

To perform a post, you do the following:
IBTable1.post;

Remark: you better change to IBQuery and IBUpdatSQL, the IBTable is an implemantion of both commands. To start with it seems nice but with large database it becomes slow.

Steph

 

[delphiman]

???

I'm not using IBTable