Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Requery() of parameterized view returns -1
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00509963
Message ID:
00510105
Vues:
16
Yes, Update All, Send SQL update and Share Connection in Advance Options has all been done. The data is being updated on the underlying Oracle table. The problem occurs when I change the parameters of the view and then Requery the the remote view. It's like the requery totally ignores the new parameter values. I can suspend the program, and manually enter in the new parameters from the command window and then browse the view and the data is not changed.

Thanks,

Greg

>Have you checked update all , Send SQL update in update criteria and Share Connection in Advanced Option of remote view ?
>
>>I have a form that contains a list box and a grid. As the user selects an item in the list box the grid is automatically updated with the items that match the selected item. The grid data is based on a parameterized remote view. This works fine except when a user makes changes to the data in the grid and saves the changes. If the user cancels the changes things continue to work correctly. To save I issue a TABLEUPDATE(.T.,.T.,'viewname'). To cancel I issue a TABLEREVERT(.T.,'viewname'). After the save, when the user select a different item in the list box, the REQUERY('viewname') returns a -1, the remote view data is not changed.
>>
>>The remote view is buffered with CURSORSETPROP("Buffering",5,"viewname").
>>
>>Does anyone have any suggestions as to how I can resolve this problem. Any help would be greatly appreciated.
>>
>>Thanks,
>>
>>Greg
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform