Writing to MySQL dB
Hi - I am using ADO to connect to my MySQL db and extract my testdata. I now need to be able to write data to a specifc field in a record.
Can't find much info on this - anyone any examples?
Re: Writing to MySQL dB
If you want to change data in your DB from TestComplete, you can execute a SQL query using the ADOCommand.Execute method. For example, the following query will assign 1 to the MyCol1 column for every record, in which the MyCol1 value is more than zero:
UPDATE MyTable SET MyCol1 = 1 WHERE MyTable.MyCol1 > 0