Thanks Dave. Finally understood what the MakeUpdateable.prg was all about. I use to see people refering to it but never realized what it was for.
Thanks Paul McNett. Is there any problem if the name of the backendtable & local alias has the same name. Since I am converting Vfp forms life will be easier if they can be both same. Just want to know in advance so that I don't fall into any trap. Ajoy Khaund On Thu, Feb 14, 2013 at 1:41 PM, Dave Crozier <da...@flexipol.co.uk> wrote: > Ajoy, > If you are using SPT and you are retrieving a cursor from SQL Server then > you set the attributes of the cursor to reflect the update behaviour using > cursorsetprop(). > > You need to set the Keyfieldlist, Tables, UpdatableFieldList, Updatetype > and Wheretype properties. Then the cursor will update automatically using > the tableupdate() method. > > To check if any fields have been updated in the cursor you can use the VFP > OLDVAL() function to determine if any field has changed or set your own > trigger in the Interactivechange event of the fields on the form. > > As for updating, you can obviously also update individual records using > spt in standard SQl i.e update <cursor> set <oldfield> = <newfield> where > <where> if you want. > > It is also worth looking at tableadapters as they take all the hard work > out of SQL if you are averse to manually programming. Personally I don't > like them but I do use them on occasions. Create the cursoradapter them to > a separate class for ease of re-use then you can easily add them into your > dataenvironment and just use them like native VFP cursors. > > On Profox there is a small routine MakeCursorUpdateable (I think) by Paul > McNett that will point you in the right direction for cursorsetprop() if > you are confused by the VFP documentation. I must admit that the > documentation isn't great. Alternatively ask away on here. > > I have my own set of classes that do all the SQL stuff automatically that > you could have but I think it would be too complex at the level you are > currently at. Once you master cursors in SPT they it may be of use to you. > > Dave > > > -----Original Message----- > From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ajoy Khaund > Sent: 14 February 2013 03:49 > To: Profox > Subject: Update table using SPT > > Hi All, > > I am working on MSSQL for an app. I am in the learning stage. I am using > SPT. I have a query. > > I have an employee master form. > In the load event I can query and get all the records down to a cursor. I > have an edit button in the form. Now the user may edit one or more fields > in the form say having 50 fields. > > On save how do I write the UPDATE command if the user has say edited two > fields. How will the app know that? > > TIA > > -- > Regards, > > Ajoy Khaund > Neamati Road > Bhogdoi Mukh > Jorhat 785001 > Assam, India > > Tel: 91-376-2351288 > Cell: 91-94350-92287 > Mail: akha...@hotmail.com > Mail: akha...@gmail.com > http://teaanalyst.blogspot.com/ > > > "Walking on water and developing software from a specification are easy if > both are frozen." > - Edward V. Berard, "Life-Cycle Approaches" > > > --- StripMime Report -- processed MIME parts --- multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/caps4rvuv0mkzwhmr1azdyx1uljmxzaom65apkurqj+79mxv...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
