Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL command reading in DELETED record
Message
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01296850
Message ID:
01296906
Views:
7
>My SQL is in a grid form. A Second maintenance form is called based on the current selected record in my grid. Changes are made in the second form & saved . Then I return to my 1st grid form.
>
>There is a command button on my first from to delete records.
>
>Once a user has made changes using the second form, and I return to the grid form, any records I try to delete are ignored by my SQL command.
>
>Hope this makes sense.. phew

It sounds like your second form changes the SET DELETED (and may be other) settings.

Try
messagebox(set('deleted')) before calling your form and after.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform