Zeoslib Portal

I'm sorry guys, I have found the problem, actually Michal is right, there is no need of the code below: Params[0].SQLType := stUnicodeString; Params[1].SQLType := stUnicodeString; Params[2].SQLType := stCurrency; Params[3].SQLType := stCurrency; I was testing with that because I have found this topi...

These lines do not compile at all for me:
Params[0].SQLType := stUnicodeString;
Params[1].SQLType := stUnicodeString;
Params[2].SQLType := stCurrency;
Params[3].SQLType := stCurrency;

It needs declaration of ZDbcIntfs unit.

Hello Michal! Params[0].SQLType := stUnicodeString; Params[1].SQLType := stUnicodeString; Params[2].SQLType := stCurrency; Params[3].SQLType := stCurrency; Before the Loop, same " Invalid Variant-Type for String-Array binding! " error... without it occurs " Unsupported parameter type,...

Hello Jan! I am not sure, if we support Batch DML on this version of Firebird because Firebird introduced its Batch API with a later version. Not sure if that was in version 3 or version 4. Well, I'm also not sure about this, but Zeos recognizes FB 2.1 with support for BatchDML, see the screenshots ...

Hey guys! I'm facing a trouble to use BatchDML on Delphi 2010, Zeos SVN 7683 and Firebird 2.1.7. procedure TForm1.Button1Click(Sender: TObject); var indice : cardinal; price, taxes : Currency; begin price := 0; taxes := 0; with ZQuery1 do begin Connection := ZConnection1; Active := false; SQL.Clear;...

Thank you Jan, it's working fine now.

Hello Jan, I created a ticket on our bug tracker for this. It will take some days for me to add a test case and see what I can do. All right, thank you! Hello Michal, I managed to get something like this: Well, I get a common AV error message and, as I said, I'm testing Firebird 4 stable, I don't kn...

Hello Jan,

I assume you use "firebird" as the protocol?

Yes, forgot to mension that.

Could you please test what happens if you use the "interbase" protocol?

Just tested, same AV hapens at the same line and unit I mensioned above.

Hey guys! I was doing some tests with Zeos 8 SVN 7589 on Delphi 2010 and Firebird 4.0.0.2496 (relase). On firebird.conf I setted DataTypeCompatibility = 3.0 property. Here is the DML of the table on FB database: CREATE TABLE PRODUCT ( ID INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1) NOT NU...

Hi Michael, your are faster on testing than me on announcing the features. LOL That's because I like Zeoslib so much and that feature will be very very much helpful for me. Bruno i'll check your examples. The FB exception should not be thrown. Thus i accapt the ticket. What i miss in your code is: Q...

Yeah, no problem.

Thanks Jan!

Hi there! I'm using Zeos SVN 7378 on Delphi 2010 + Firebird 2.1 testing new behavior of TryKeepDataOnDisconnect property on datasets. Considering the sequence of the code below, it causes the EZIBSQLException = -904 Message: isc_dsql_allocate_statement. #1 - Connect the database and open the query w...

I'm using Delphi 2010 and ZeosLib SVN 7336... I have a combination of ZConnection > ZQuery > DataSource > DBGrid. ZConnection is connected to a remote Firebird 2.5 database and, after some time, it is normal to be auto disconnected from the database for inactivity... that's ok... when that happens, ...

DestinationDataSet.Append; For a := 0 To SourceDataSet.Fields.Count - 1 Do DestinationDataSet.FieldByName(SourceDataSet.Fields[a].FieldName).AsBytes := SourceDataSet.Fields[a].AsBytes; DestinationDataSet.Post; I'll try this aehimself, thanks for the tip! I'll chek what going on if a connection is a...

Keep the connection on only until you need it.

That's it Man!!!

Are you using Delphi or Lazarus?

Both of them, Delphi 2010 and Lazarus 2.0.10.