ADOdb recordset update

[Max71]

Do anyone knows how to update a recordset in a mySQL DB using LV7.1.1, LabSQL (free library), and ADO?

[Dennis_Knutson]

Are you looking for the SQL syntax or which function to use in LabSQL? The syntax is:

UPDATE table_name [options] SET col_name = expr,... [WHERE clause]

as in UPDATE testres SET meas2 = 2.5 WHERE meas1 < 0

The function in LabSQL to use is SQL Execute. Set the Return Data input to false. You would first use ADO Connection Create and ADO Connection Open.

[Max71]

Thanks a lot, this work.

I'd like to know something about ADO.update method, and the use of variant data