Gene

Members
 View Profile  See their activity

  • Posts

    2

  • Joined

  • Last visited

Gene's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. Gene
    Thank you, that corrected it, first try! Working on proof of concept, thank you for the suggestions, will definitely be incorporated.
  2. Gene started following Concatenating strings
  3. Gene
    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