Syntax error Insert INTO

mo555 · #1 (**permalink**) 09-26-10, 05:15

qrybiology.Close;
qryBiology.SQL.Clear;
qrybiology.active:=false;
qrybiology.SQL.add('INSERT INTO tblstudents(username,Password,sName,sSurname,Cellp hone,Grade)'+
' VALUES ('''+ edtnewusername.Text + ''','''+ edtnewpass.Text + ''','''+ edtname.Text + ''','''+ edtsurname.Text + ''','''+ edtcell.Text + ''','''+ edtgrade.Text + ''')');
qrybiology.ExecSQL;
qrybiology.active:=true;

i receive a syntax error in the INSERT INTO statement... please advise...

it-iss.com · #2 (**permalink**) 09-26-10, 07:19

Hi,

the code

Code:

qrybiology.SQL.add('INSERT INTO tblstudents(username,Password,sName,sSurname,Cellp hone,Grade)'+
' VALUES ('''+ edtnewusername.Text + ''','''+ edtnewpass.Text + ''','''+ edtname.Text + ''','''+ edtsurname.Text + ''','''+ edtcell.Text + ''','''+ edtgrade.Text + ''')');

Are you sure about the "Cellp hone". This might be Cellphone?

Tharaka Deshan · #3 (**permalink**) 09-30-10, 23:23

Yeah, "Cellp hone" is the only case I got as a problem.
MySql allows spaces in field names.But I hope you had not do so.
So it may be a printing mistake.
Good Luck!

Internet Services

Web Development

Digital Marketing

Consumer Tech