>Hello Troops:
> Is there a way in vfp to open a table in a private data environment and delete all the records in that table, without really deleting records permanently from that table in the database.
>For example, I want to be able to delete all the records in Mytable.dbf in a private data session and populate Mytable with the records from mycursor to populate the grid. When I am done with that form and I want to reuse the records from Mytable, the orgional records are not really deleted.
>Something like that. LOL
>MA
Not really, unless you delete all, populate the table with your records, display it in the grid and then delete your records and recall all the other records. Not a good approach IMO.
Here's another way. In the form's Load event, try:
select mytable
=afields(lastru,"mytable")
create cursor mytemp from array lastru
* populate cursor here
Use this cursor as the grid's record source.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao