Information générale
Catégorie:
Conférences & événements
>>>>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 .
Deleting a record in a query doen't mean its deleted in the original table as well. You should issue tableupdate to get the job done. The reason is youre working in a view and not straigth away on the table. In other words your change is buffered.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement