×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Posting to an SQLTable using Delphi 6 and Interbase 6.

Posting to an SQLTable using Delphi 6 and Interbase 6.

Posting to an SQLTable using Delphi 6 and Interbase 6.

(OP)

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?

RE: Posting to an SQLTable using Delphi 6 and Interbase 6.

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

if ADataSet.state = dsEdit then
;

Opp.

RE: Posting to an SQLTable using Delphi 6 and Interbase 6.

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

RE: Posting to an SQLTable using Delphi 6 and Interbase 6.

(OP)
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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close