Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deleting from a grid?
Message
From
13/06/2004 18:18:40
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
13/06/2004 18:09:13
Randy Wessels
Screentek Business Solutions, Llc.
Phoenix, Arizona, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00913250
Message ID:
00913276
Views:
20
You should check whether you have SET DELETED ON - this command will hide deleted records.

Also, if you want to make changes to the original table (on which the cursor is based), use a view instead of a normal cursor, and make it updatable.

>I am getting closer. I had to make my cursor READWRITE. My problem now is that it deletes from the grid, but when I go back in and view it, the deleted record is still there. Here is my cursor in the init even of the form:
>
>SELE recno, paynum, invno, custno, invdate, type, refno, applied from cashtemp ;
> INTO CURSOR curCustWithCash READWRITE where custno = currentcustno
>CURSORSETPROP("Buffering",5)
>thisform.grid1.RecordSource = "curCustWithCash"
>
>Here is the code I out in that you recommended:
>
>If Messagebox(.....
> Deelte
> Tableupdate()
> This.parent.parent.Refresh
>Endif
>
>Thanks for the help - I am almost there.
>
>Randy Wessels
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform