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?

 

[Oppenhiemer]

Hi
You can use the "State" property of the TIBDataset object and compare it to dsEdit.

if ADataSet.state = dsEdit then
;

Opp.

 

[svanels]

Check out the example in the CachedUp directory, they make use of all IBX compenents, especially the dataset.

Regards Steven van Els
SAvanEls@cq-link.sr

 

[delphiman]

Opp.
I don't understand your suggestion. please elaborate

Steven.
<the example in the CachedUp directory
This refers to a DataBase which didn't come with my
D6 installation. But in any case from just looking looking at the code I can see there is nothing there that answers my question.

I'v started another thread wherein I put the question differently - and more clearly I hope.