General information
Category:
Coding, syntax & commands
>Thanks! The select statement works, then I just check _TALLY to see if it was found.
>
>How about this; when I add a record to the buffer, and then issue an SQLCOMMIT, Foxpro updates the remote table but LOSES my key field. It is now 0 in the remote table. I can see the correct value in my cursor, I issue the SQLCOMMIT, close the cursor, reopen it, and the key value is 0. Of course, the next time, it won't COMMIT, as there is already a 0 there.
>
>Anyone?
Perhaps it is because Fox doesn't make keys automatically updateable? I know that in the view designer, you have to explicitly set key values to updatable. Even 'Update All' will not update keys.
HTH,
Scot.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only