Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
UPDATE - SQL
Message
From
05/01/2001 06:38:24
 
 
To
05/01/2001 04:01:23
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00459690
Message ID:
00459711
Views:
18
Hi!

Its depended on the buffering mode of you view. If buffering mode is row

Cursorgetprop('Buffering') = 3 && CursorSetProp('Buffering',3) - how to set up it

Record updated automatically when you move to another record. I guess UPDATE SQL when finished on another record than updated by command, updates are sent automatically.

With buffering 5 (table buffering) all rows are buffered, thus you require to use tableupdate() function. For table buffering mode, tableupdate have special parameter to ensure all records in view are updated despite the current location of record pointer.

You can also ensure that all records updated using getnextmodified(0) finction, when it returns 0 - no changed records in view, all are updated.



>When I use an UPDATE I want to issue TABLEUPDATE() afterwards, but it may not be on the record that has just been updated, how can I ensure that a view that I UPDATE is COMMITTED.
>
>Thanks
>Kev
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.com
ICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs

It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform