ZSQLProcessor parameter
lazarus / 16-Databases

----------------------------------------------------------------------
Hansvb · 2016-03-07 19:48

With ZSQLProcessor i run some pl/sql script.

Now i have a script dat has a ":"

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
declarel_teller   number(10) := 0;begin   ...end
I changed the paramchar to "@" instead of ":".  But that does not
help. I can set the paramcheck to false but i think i will need that
in the near future. Is it possible to run such a script with
ZSQLProcessor?

(Until Lazarus 1.4.2 i ran these scripts with the TSQLScript. But in
Lazarus 1.6 that does not seem to work anymore. i guess i do something
wrong).

----------------------------------------------------------------------
EgonHugeist · 2016-03-09 08:05

which delimiter do you use?

i've attached a create-script from the Zeos tests. As you can see it
works pretty nice if you use the SetTerm logic. The terminator adapts
to the preferred logic of the RDBM's or better said custom known
logic.
The attached file demonstrates how to use same logic like FlameRobin
is doing that.

Hope it helps.

----------------------------------------------------------------------
Hansvb · 2016-03-12 15:59

I looked at you're script. I does not use pl/sql with a var.
ZSQLProcessor works fine with create statements. That works for me
too. I want to excecute a PL/SQL statement with a var. The next
statement does not work (with me).

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
declarel_teller   number(10) := 0;begin  null;  --empty, just want to
to test a declare with a :=end;^

If i do not check for paramaters than the above works fine.
I tried to  change the parameter to a "@" and then put the check for
parameters on again. The statement is not executed anymore.