Re: problems with insert sintax
still doesn't work, i receive Syntax Error
Code:
ERROR [42000] [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
Syntax executed :
Code:
"INSERT INTO Players (idPlayer,idTeam,playerName,number,position,of_id,face,hair,boot)VALUES (52862,141,'M. Matei',23,'CF',23,'fals','fals','fals')"
I must say you that in the DB i have more fields than i used in the syntax( i have ID (auto-number) and "available" as true/false field.)
last 3 fields used in the syntax (face , hair, boot) are declared as text in database
Re: problems with insert sintax
Open Microsoft Access. PASTE (not type) the QUERY into the SQL view.
1) Does it Run?
2) Did the Designer change the Syntax?
Re: problems with insert sintax
lol the error was because column "number". i changed the name(because access had sth wrong with this) and now i will try in VB, but i think it works now