Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Delete records and requery
Message
General information
Forum:
Visual FoxPro
Category:
Conferences & events
Miscellaneous
Thread ID:
00012109
Message ID:
00012557
Views:
47
>>>I have a list box based on a table. The user can choose to delete a record from the list box. After I used a SQL statment to delete the record, it still appears in the list box even though I REQUERY the form. I tried the PACK command, but it will close all my table and the entire list box becomes blank.
>>>
>>>How do I REQUERY the table from a list box after I deleted a record?
>>
>> did you try to .REFRESH() the list box
>>
>>Arnon
>Also try setting DELETED ON, a requery will still pull in deleted records.
>
>HTH,
>Greg

Not sure about this in VFP but you are probibly still sittin on the deleted record. Try going to a new record with skip or something .
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform