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:
00750106
Views:
27
If you need to use the deleted flag, it should be quicker to combine her idea with mine. You can then omit the lDeleted field from grids.
< view definition >
SELECT *,deleted() as lDeleted from table1 where ...
....


< when you use the view >
USE view1 in 0
select view1
delete for lDeleted 
>
>Also found a message (Thread #675313, Message #675350) with a workaround for this problem but would like to find a better way.
>
>Best regards,
>
>Todd
Steve Gibson
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform