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:
00750189
Views:
24
Todd,

So it is an updateable view...I was afraid there might be other issues with that.

Does the user also need to be able to recall a previously deleted record?

>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
Steve Gibson
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform