>>I have a form with a grid based on a view.
>>
>>After the TableUdate() in my save method, I issue a Requery() on the view and a Refresh() of the form.
>>
>>For a reason I don't know, the Requery() doesn't seem to work, because the grid appear empty. I tried the Next and Previous button, but the grid still appear empty. If I quit the application and go back in, I will see my new record.
>>
>There is a good habit: any time you see problems with grid issue something like:
>Thisform.Grid1.Recordsource=Thisform.Grid1.Recordsource
I tried, without success.
When stepping through my code, I found a weird behaviour:
- Right after the Requery() I browse the view and it show no record
- I browse the table "Products" (the view is a join between "Products" and "ProductList")
- I browse the table "ProductList"
- I re-issue the Requery() from the command window
- I browse the view and it now show my new record
Any ideas what's going on?
Précédent
Suivant
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