Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View Turns Deleted() Off
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00750048
Message ID:
00750119
Views:
35
Steve,

I just tried a solution almost identical to yours and it displays the deleted records correctly but found it created a reverse problem: it wont delete records in the underlying table.

I added "deleted() as delflag" to my view sql as you described.

In my Save button:

select viewname
delete for delflag = .t.
tableupdate(.t.)

Seems to not like delflag as the bound control souce in the check box on my grid.

Im tempted to just add my own logical "delete field" to the table and be done with this. It just doesnt seem that should be necessary...

Todd
The day you take complete responsibly for yourself, the day you stop making any excuses, thats the day you start to the top. - O.J. Simpson

Great advice from a questionable source...
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform