How    .ParamCheck=false in TIBconneciton ?
lazarus / 16-Databases

----------------------------------------------------------------------
Fortuna1 · 2012-05-25 06:03

I use in ZEOSquery.ParamCheck:=false;




Code: [Select]
ALTER PROCEDURE DDV_KNJIGA (
    VLISTA Smallint,
AS
BEGIN
INSERT INTO DDV_KNJIGA_TEMP(
  KEY_DOK,   
)

SELECT
:VLISTA, ....

How programing ExecSQL    alter procedure?
How    .ParamCheck=false in TIBconneciton ?

----------------------------------------------------------------------
ludob · 2012-05-25 06:33

AFAIK there is no equivalent of .ParamCheck:=false in sqldb. Use
TIBConnection.ExecuteDirect(); which does not do any sql parsing or
parameter checking.

----------------------------------------------------------------------
Fortuna1 · 2012-05-25 07:11

excellently.
Thank you.

I' am charmed of hopes TIbconnection.
connection to DATABAZE is several times quicker as  ZEOSconnection.

And  first  SELECT ALSO a lot quicker  from ZEOSA select.