How to Insert a new record or update a record in MS sQL

Topics: Developer Forum
Feb 28, 2016 at 6:25 PM
Hi Good Fellows
am new in avfp and i want to know how to insert records or update records using AVFPsql. for now i can only connect and open tables in Ms Sql but cannot insert a record or update. I haved try what i know but seems not to work.
The example in documentation did not teach us how to insert or update MS sql table. Please can anyone help me ?
Feb 29, 2016 at 5:26 PM
That is because inserting or updating rows in MS SQL (or any other ODBC source for that matter) from AVFP serverside code is no different, in any way, to doing the same thing in a regular VFP client-server app.

Maybe you should first learn how to interact with MS SQL from VFP (using SPT, remote views or DataAdapter), and then try to apply those skills in AVFP.

Victor Espina