Zeoslib Portal

Hi, I executed this script with TZSQProcessor and had the message below : SET TERM ^ ; CREATE PROCEDURE GET_CREDIT_BY_STRUCT ( cr_idstruct smallint, cr_chap char(5), cr_art char(2), cr_par char(2), cr_aln char(2), cr_date date) returns ( tot_bp decimal(15,2), tot_bs decimal(15,2), tot_br decimal(15,...

Hi Mark, I'm using FB 2.0 with Zeos 662. Here is the portion of the code I used : procedure TfrmMain.mnFraisClick(Sender: TObject); var myConnection : TZConnection; myQuery : TZQuery; qStudent : TZReadOnlyQuery; sYear, dbName, expDir : String; n : integer; begin expDir := ''; if SelectDirectory('Cho...

Hi there, I tried to export some data from one table of a DB to another table of another DB. The first exists yet but the second is created at run time. I'm using one TAQuery to fill my table and a TZReadOnlyQuery to read the existing table. Process : Create DB and Table to fill, open ZReadOnlyQuery...

Hi GTO,

Is my script correct or bugged ??

Need other information ??

Regards.

Here is the script : SET TERM ^ ; CREATE OR ALTER PROCEDURE GET_PROV_BUD_GLOB ( mychap char(5), myart char(2), mypar char(2), myaln char(2)) returns ( tot_bp decimal(15,2), tot_bs decimal(15,2), tot_br decimal(15,2), tot_vir_e decimal(15,2), tot_vir_d decimal(15,2)) as begin /* BP */ select sum(dota...

Hi,

I wrote an SQL script which works fine on IBExpert but when I tried to execute it under an SQLProcessor, I had this error :
Invalid request BLR at offset 291 bad parameter number.

I'm using Zeos 6.6.2, Firebird 2.0.3 and D7.

An idea about this message ?? Thanks.

Is it possible to call a stored proc from trigger ?
An example ???


I'm using FB 2.0 and zeos 6.6.2


Thanks.

Hi, I'm newer in Zeos and Firebird, then, I think, my question will be so easy for you but seems so difficult for me. Ok. How Can I create a new DB with FB server on disk ?? Wich Zeos component I use ?? I tried creating it this evening. I used TZSQLProcessor component but it has to be connected to T...

Ok, thanks.

I'm using FireBird Emb. v2.0.

I'll focus my debugging in this direction and let you know what happened !

Thanks again.

Thanks for your response.

But which DLL you're speaking about ???

Hi,

I installed recently the 6.6.2-rc zeos version on Delphi 5 Pro and had the problem below :

On runtime all is ok. Fine. But at Design time when I try to connect my Zconnection (Set connect to True), I have an Access violotion in VCL50... message !

Any one has an idea about ???

Thanks.