Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Delete records in a table that a Grid is linked to
Message
From
04/12/1998 05:00:22
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00163988
Message ID:
00164003
Views:
28
>How do you access a table that a Grid is linked to so you can delete the records in the table or manipulate the table in other ways and then refresh the grid to show the changes? The form's DataEnvironment has the table active and I guess this is why I can't open it to access it with the USE command. -OR- How do you manipulate the Grid to delete all the rows/records in it so that it deletes them from the table?

Select (thisform.mygrid.recordsource)
delete for lMyDeleteExpression
* delete all + pack = zap - needs excl access
* and neither pack nor zap is suitable actions
* to perform on a data entry form (IMHO and arguable of course)
thisform.mygrid.refresh
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform