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:
01296910
Views:
8
I set a breakpoint on SET DELETED ON & nothing happened?

Could this be a buffered data problem?

>>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.
Rob
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform