Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deleting records using SQL Delete in Grids
Message
 
 
To
05/08/2001 17:57:18
Henry Ravichander
RC Management Systems Inc.
Saskatchewan, Canada
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00538999
Message ID:
00539948
Views:
12
It's overkill to pack a table after every delete.
SET DELETE ON
will make deleted records invisible. The following code would delete the current record in the table and refresh grid
*DELETE BUTTON - CLICK EVENT
SELECT rev_locations
DELETE
<b>This.Parent.Grid1.Refresh()</b>
>Sergey:
>
>I put in the code you suggested in the Delete button. The result was the the grid did not refresh to show that the deleted record was gone. I then put the statement PACK after your code, then I got a message saying file must be opened exclusively. After deletion, I want the grid to refresh to show the remaining contents of the table.
>
>I probably am missing something else. In the code I gave you, all I did was took out the SQL Delete statement and replaced that with your code.
>
>Thanks.
>
>- Ravi
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform