[SOLVED]insert without parambyname
lazarus / 16-Databases

----------------------------------------------------------------------
majid.ebru · 2017-05-15 14:26

Hi
.
i use this code :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  ZQuery1.ParamByName('NamePerson').AsString:=
EditPerson_Name.Text;and insert data to DataBank and this code work
corectly.
.
how can i insert data to bank without "ParamByName" , like use index
number?
.
i use these codes,but don't work
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
 ZQuery1.Params.Items[0].AsString:=
EditPerson_Name.Text; and  ZQuery1.Params[0].AsString:=
EditPerson_Name.Text;"ParamByName" .
i don't want to use "ParamByName",is Replace code ?!?!

----------------------------------------------------------------------
valdir.marcos · 2017-05-15 17:11

Quote from: majid.ebru on May 15, 2017, 04:26:41 pmHi
.
i use this code :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  ZQuery1.ParamByName('NamePerson').AsString:=
EditPerson_Name.Text;and insert data to DataBank and this code work
corectly.
.
how can i insert data to bank without "ParamByName" , like use index
number?
.
i use these codes,but don't work
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
 ZQuery1.Params.Items[0].AsString:=
EditPerson_Name.Text; and  ZQuery1.Params[0].AsString:=
EditPerson_Name.Text;"ParamByName" .
i don't want to use "ParamByName",is Replace code ?!?!

Try:
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  
SQLQuery1.Params[0].AsString := 'Paul';
Maybe, your error is in the lost word "ParamByName" in the end of your
line:
ZQuery1.Params[0].AsString:= EditPerson_Name.Text;"ParamByName"

What error message are you receiving?

----------------------------------------------------------------------
miab3 · 2017-05-15 17:38

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
ZQuery1.Params[0].AsString:= EditPerson_Name.Text; // or
 ZQuery1.Params[0].Value:= EditPerson_Name.Text;ZQuery1.ExecSQL;should
work.

Michal

----------------------------------------------------------------------
majid.ebru · 2017-05-15 18:20

so sorry i mistek