• Registered: 2015-10-13
  • Posts: 38

Topic: Using script to insert a new record

Hi, a little help please. Is it possible to insert variable data (this is not data from a textbox) into a table using SQLExecute. If so how is it formatted. I have tried
SQLExecute('INSERT INTO Tablename(Field,Field) VALUES("'+variable+'"."'+variable+'")'); and various combinations with out any luck. Any advice would be appreciated.

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Using script to insert a new record

Hello.

SQLExecute('INSERT INTO Tablename(FieldName1, FieldName2) VALUES("'+variable1+'", "'+variable2+'")');
Dmitry.