Error Insert Query
lazarus / 16-Databases

----------------------------------------------------------------------
Deepaak · 2017-10-20 11:08

MSSQL Server 2008

Cannot Execute. How to put comma between in two or more field name.
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
Query.SQL.Text:='INSERT INTO Info(Email, Phone) values(' +
QuotedStr(edtEmail.Text)+ ''',''' + QuotedStr(edtphone.Text) + ')';

----------------------------------------------------------------------
taazz · 2017-10-20 11:12

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
Query.SQL.Text:='INSERT INTO Info(Email, Phone) values(' +
QuotedStr(edtEmail.Text)+ ',' + QuotedStr(edtphone.Text) + ')';

----------------------------------------------------------------------
Deepaak · 2017-10-20 11:20

Thanks...

----------------------------------------------------------------------
rvk · 2017-10-20 11:20

Or how about:
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i  
Query.SQL.Text := 'INSERT INTO Info(Email, Phone) values(:email,
:phone)';  Query.ParamByName('email').AsString := edtEmail.Text; 
Query.ParamByName('phone').AsString := edtphone.Text;It's better to
use parameters anyway.