Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Requery() of parameterized view returns -1
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00509963
Message ID:
00510041
Views:
18
Hector,

I believe the syntax is ok. Since all parameters are optional and the value for nRows can be either .t./.f. or 1/2 with the default being 0. I have tried various combinations of TABLEUPDATE when the same results. TABLEUPDATE is returning .T. and the underlying data is being updated.

Any other thoughts would be greatly appreciated.

Thanks,

Greg

>I am not sure you are using the right syntax for TableUpdate(). Help says:
>
>
>TABLEUPDATE([nRows [, lForce]] [, cTableAlias | nWorkArea]
>[, cErrorArray])
>
>
>Also, What value is TABLEUPDATE returning to you? Maybe there is an error in the data and VFP cannot save it to the base tables.
>
>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform