Zeoslib Portal

SOLUCTION FOUND!! I need use Zquery with ParamCheck property = false. I don't know what does ParamCheck mean but if I set it = false my code works correctly: StoProc:=TStringList.Create; StoProc.add('CREATE PROCEDURE NOME (CRCURL BIGINT) RETURNS (URL VARCHAR(100))'); StoProc.add('AS'); StoProc.add('...

I tried but I've same issue with ZSQLProcessor also. This is my code: StoProc:=TStringList.Create; StoProc.add('CREATE PROCEDURE NOME (CRCURL BIGINT) RETURNS (URL VARCHAR(100))'); StoProc.add('AS'); StoProc.add('DECLARE VARIABLE aCRCDominio BIGINT; '); StoProc.add('DECLARE VARIABLE aCRCPercorso BIGI...

I'm using Firebird, how can I create a Stored Procedure in a database with zeos ?
I tried using zquer.sql.add and zquery.exec but if the procedure is too long I receive error.

Thank You

SWEEP is a Firebird command.

When you delete a field in Firebird, it don't really delete it but simply mark it as deleted.
When you do sweep Firebird cleans all not necessary data from database and defragment so you have better performance and less hard disk space required.

I need to perform manually sweep my embedded database using zeoslib.

How can I ?

Thank you

seawolf wrote:It looks like Blob is a primary key or a part of .. why don't you use a generator instead of a Blob? (or something else)?

I finally solved my issue, thank you

Hi, You need to add more infos: 1. Which Zeos version do you use? 2. Is that field a not null field? 3. Silly questions .. is there some data on that field? and if you type "select * FROM mytable WHERE id=2" the result is one or more record? 4. Is a blob subtype 0 or 1? (I mean is a binar...

If I do:

SELECT myblobvalue FROM mytable WHERE id=2

I receive a null answer.
How can I do ?

Thank You

I used with mysql this syntax

CAST (0x... AS BINARY) but now with Firebird it doesn't work ?

How can I do ?

Thank you

Probably I discovered what happened, using TZSQLMonitor I received this message: 2008-07-11 20.07.09 cat: Transaction, proto: firebirdd-2.0, msg: unsuccessful metadata update PROV2 CHARACTER SET ISO8859_1 is not installed, errcode: -607, error: This operation is not defined for system tables. How ca...

I'm using firebirdd-2.0 protocol (but I tried also with 1.5), Zeos 6.5.1 and Lazarus 0.9.24. This is my code: procedure TForm1.Button2Click(Sender: TObject); begin ZConnection1.User:='sysdba'; ZConnection1.Password:='masterkey'; if not ZConnection1.Connected then begin ZConnection1.Database := 'db1....