>What I am trying to do: > 1-Allow my user to create a from a > program at run-time. > Using drag-n-drop techniques the user can > select fields from one of several tables and > arrange for a SQL query to produce a view > within a database. > 2-Use the view fields on an input screen and > update the view so that the base tables are > updated for those fields that are participating > in the view. >Problem: > The base tables are not being updated. > The input screen refects the changes, but after > exiting and going through the update process, > the original values still appear next time the > view is used. >Note: However, from the Foxpro command window I can > open the same view, change field values and > update it so that the base tables are changed. > >Code used and what I have tried: > I know the following: > dbget/setprop is used at design time while > cursorget/setprop is used when working with views > at run-time. > I am aware of the need to use following: > CURSORSETPROP("SendUpdates") = .T. > CURSORSETPROP("Buffering") = 5 > CURSORSETPROP( "KeyFieldList") defining the > index fields (always required). > I have tried creating these below and letting > Foxpro create them for me. > CURSORSETPROP( "UpdateNameList") > CURSORSETPROP( "UpdatableFieldList") > TABLEUPDATE(1, .T.) && with force and without > >When I issue TABLEUPDATE it returns .T. with NO errors. >Question: > Why aren't the base tables being updated? > > Thank you very much for your time. > Any help or advise will be deeply appreciated. > > Herb Cohen and Denny Jacob
Hello Denny,
Don't leave your CURSORSETP() hanging. I mean put them with IF and try.
IF CURSORSETPROP("SendUpdates") = .T. WAIT WIND 'Error' *--- Your code ENDIF