Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Pack a table while used in a grid
Message
From
02/04/1999 04:18:58
 
 
To
01/04/1999 08:53:34
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00203892
Message ID:
00204572
Views:
14
Ed,

An approach I used (with smaller-sized cursors) would be to copy the records into a temporary (non-grid) table, do a ZAP (instead of a PACK), then copy these back into the original cursor. I discovered in a few cases, an approach like this did not generate the Illegal Operation with temp relationships in force.

I wouldn't have thought about doing the same for a large table though (ala advice to Pascal)

Kenneth.


>Yes, it's really risky to employ both dynamic grid and temp relationships.
>
>>Ed,
>>
>>Some additions to this. I had temporary Relationships in force on the grid, when the PACK was issued, I got an Illegal Operation.
>>
>>Kenneth.
>>
>>>>Is there a way to pack a table in the Data Environment that is currently used by a grid as its record source?
>>>>
>>>>When I tried to do it, I was able to pack it, but then, even after adding some records to the table, my grid would become all white, not showing anything.
>>>
>>>It's possible, but takes some additional coding: basically, you should restore grid settings (first of all, recordsource and column.controlsources) after PACKing.
>>>Why do you need in this functionality? Usually, SET DELETED ON is sufficient.
Kenneth.
Previous
Reply
Map
View

Click here to load this message in the networking platform