Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Buffered table is not refreshed
Message
From
28/12/2000 06:11:11
 
 
To
28/12/2000 05:58:49
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00457255
Message ID:
00457268
Views:
25
Hi!

> Does VIEW support CURVAL() and OLDVAL()?

Yes. However, you should use refresh() command for view to get latest values for CURVAL() from server. For tables you need to adjust SET REFRESH command parameters only.

> Again, I am not using view, instead i am using base table with table buffering. Any siggestion?

Hmm, if recall does not works with buffered tables - this is a bug. Try to work in 'SET DELETED OFF' mode, maybe here is a clue.
Anyway, this way is obsolete. With SQL Server recall will never work, only method of new record insertion does works.
Finally, this functionality (record restoring when it is deleted by another user) in most database systems is not supported and such record either added as completely new (with new ID # for key) or just ignored/deleted even when user changed something.
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