Zeoslib Portal

Hi marsupilami, I set in my source code the follow commands: with cdsAutorizar do begin try Active := False; CommandText := 'SELECT VENDABUSCADESC FROM GETPERMISSAO(27400001)'; Open; except on E:Exception do begin ShowErrMsg(E.Message); end; end; end; But i already receive the same error: SQL Error:...

Hi, I am trying to execute in a clientdataset the follow command text: SELECT VENDABUSCADESC FROM GETPERMISSAO(27400001) But i receive ths error: Remote error: SQL Error: request synchronization error; GDS Code: 335544364; Unsuccessful execution caused by system error that does not preclude successf...

Hi, I changed to LargeInt the INT64 field and it works. With BCD field i have this situation now: object cdsClienteLIMITE: TBCDField FieldName = 'LIMITE' Origin = 'GETCLIENTE.LIMITE' Precision = 32 Size = 2 end The field above is giving the error "expecting BCD actual: FMTBCDField". I chan...

Hi, We use FIBPlus in our application and we are changing to ZEOS framework. In the FIB exists a property in the dataset (PrepareOptions) called psSQLINT64toBCD, when i check this the BIGINT in the Firebird is treated like type BCD size 0. Is there something like this in the ZEOS? In the moment i am...

Hi, I'am using Firebird 4.0 and Zeos 8.0 with Delphi XE2. In the form i have a TClientDataset, TDataSetProvider, TZQuery, 2 TZTransaction(Read and Write). Then when i give a Active := True in the clientdataset and that don't have return(RecordCount = 0), my database is empty, i receive the error: Ro...

Hi, i resolve removing this property in the options of my TDataSetProvider: poIncFieldProps

Hi, I have a ZConnection and a clientdataset that return to me a DATE field in the Firebird 4.0. But when i give a Active true in the component, return to me: [02/08/2022 16:54:13] [UDMSERVER]FALHA ao conectar no BANCO DE DADOS: 192.168.0.14/4010:D:\BD\FRENTE_4.FDB Error reading cdsGetProcedimentoDA...

Hi, i have a sql script in the Firebird 4 that is like it: EXECUTE BLOCK RETURNS (EXISTE INTEGER) AS BEGIN EXISTE = 0; IF (EXISTS(SELECT 1 FROM RDB$PROCEDURES WHERE RDB$PROCEDURE_NAME = 'VEC_OBTERVERSAOEC')) THEN EXISTE = 1; SUSPEND; END I would like to run this sql and get the Field EXISTE in the r...