Gene

Thank you, that corrected it, first try! Working on proof of concept, thank you for the suggestions, will definitely be incorporated.

Having issues concatenating strings. function SQL_ADD_TEST(string SER_NO, string FIRST_HIGH, string FIRST_LOW, string SECOND_HIGH, string SECOND_LOW, string THIRD_HIGH, string THIRD_LOW) local dbase = db.Open("Daq351") local executeSTR = Format("insert into app01 (serialnumber, firsthigh, firstlow, secondhigh, secondlow, thirdhigh, thirdlow) values ('%s', '%s','%s','%s','%s','%s','%s')",SER_NO, FIRST_HIGH, FIRST_LOW, SECOND_HIGH, SECOND_LOW, THIRD_HIGH, THIRD_LOW) local inserts = db.Execute(dbase,executeSTR) db.Close(dbase) return inserts when trying to output to console with ? executeSTR, i get NaN. I've also tried "insert into...." + value1 + ", " + value2 " but get an error saying it expected a number (in general, i can get the actual error again). if I hard code the sql, this sequence works fine. thanks in advance, gene