Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
=TableRevert(.T.)
Message
From
09/05/2001 02:58:00
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
08/05/2001 13:33:40
Chuck Tripi
University of Wisconsin - Milwaukee
Milwaukee, Wisconsin, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00504832
Message ID:
00505148
Views:
18
Chuck,
Sorry but I still couldn't get why tablerevert() wouldn't work. Just create a wizard one-to-many test form. Wizard forms use buffering and tablerevert().
In a buffered table unless it's row buffered there is nothing updating data till you call tableupdate().
If for a moment I could think it wouldn't work then a view that's not sending updates or a cursor might be another option.
Transaction is another alternative (wizard QBE form uses this technique).
If It wouldn't do too I would use old fox2x style memvar scattering-gathering rather than inserting and deleting.
Cetin

>I have SELECT person in the form Init (for in order to make the grid have only related records), so I am assuming that's why this revert command won't work. The form has two "display" fields from PERSON and the rest is from AUTH table (both fields and grid). Either way, I tested it and does not work.
>
>Chuck
>
>>>I am using INSERT INTO auth (id) VALUES (person.id) for the 'Add' button, so, I can not use =TableRevert(.T.), but have to use DELETE (but not PACK) for the 'Esc' button?
>>
>>Chuck,
>>Why can't you use tablerevert() ? You could as long as 'auth' is buffered.
>>Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform