I'm having a heck of a time with syntax errors. If I make the statment
It will insert this column.
But, If I try to add more fields, it won't:
The column names are correct, including case. There are actually 47 columns, but as I understand it, I do not have to send all.
The last example gives the sql syntax error in the statement. The statement comes out as such:
I've also tried placing "','" (Single quotes inside the double quotes as in the sample SQL_Tools programs to no avail. ai() are string valuse.. The database fields referenced ate Numeric, TEXT and TEXT
Code:
sqlstmnt = "INSERT INTO VC (AudioIndex) VALUES (" + ai(1) +")"
But, If I try to add more fields, it won't:
Code:
sqlstmnt = "INSERT INTO VC (AudioIndex,Filename,LongFilename) VALUES (" + ai(1) +"," +_ ai(2) + "," + ai(3) +")"
The last example gives the sql syntax error in the statement. The statement comes out as such:
Code:
INSERT INTO VC (AudioIndex,FileName,LongFilename) VALUES(5,,C:\DRIVE E\F\Checked MP3 Files\5th Dimension\01 Up-Up and Away = The 5th Dimension.mp3)
Comment