Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updating of SQL View-based cursors
Message
 
To
09/09/1998 10:04:58
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00134498
Message ID:
00134805
Views:
9
Sounds like you're not calling TABLEUPDATE() correctly. Between 3.0 and 5.0 the syntax became somewhat confused. The help entry implies that you can pass .T. or .F. as the first parameter, and that it signifies whether to force the update. In fact, the first parameter is numeric, and the SECOND parameter is whether or not to force the update. Try doing TABLEUPDATE(1, .T.) and see if that works.

>Hi all.
>
>Do You know, why the cursor, that based on SQL-View, buffered in "Optimistic Table" mode and
>contains no records when it created, could not be updated correctly?
>
>In details, when I add some records into that cursor and try to use TABLEUPDATE( .T. ) command,
>one new record is adding to the bottom of cursor, and it comes to many new problems, such as
>impossibility of buffer reverting, staying of uncloseable private DataSession after form releasing, etc.
>
>Such problems is taking their place to when I trying to update all records one by one.
>
>What can I do with this?
>
>Thank You, sorry for bad English.
>
>Dmitry Belyaev
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform