Zeoslib Portal

I use TClientDataSet and DataSetProvider because makes life easier when updating datasets that show db Views, allowing to specify the underlying table that should be updated on the OnGetTableName of the DataSetProvider. Most of my DataSets shows db Views which data can be updated by the end user, an...

I eliminated the block of code you suggest and recompiled ZAbstractRODataSet.pas; the system seems to work Ok.

File ZAbstractRODataSet.pas, Line 3024: Changed from Statement.SetInt(I + 1, ParamValue.AsInteger); To Statement.SetLong(I + 1, StrToInt64(ParamValue.AsString)); File ZAbstractDataSet.pas, Line 688: Changed from Temp := Integer(SrcField.OldValue) To Temp := string(SrcField.OldValue); Regards, Guille...

Yes, it was a bug. I replaced the code with Int64 type and now it works.

This seem to be a bug in Zeos components v6.6.4. I replaced the Connector and Query components of Zeos, with a commercial set of dbExpress components for MySQL ... and the problem has been solved.

I found the problem. Was my error.

'm using Delphi 7, MySQL 5, ZeosLib. I'm using ZQuery components, DataSetProvider, ClientDataSet; when I want to apply a Filter using the"Filter" property of the ClientDataSet, it is simply ignored; the code is: with self.z_dataSet do begin Active:=True; Close; Filter:= self.z_claseObjetoP...

Hi, I have Delphi 7, ZeosLizb components and MySQL 5. The Connection and Query components are Zeos, and each Query is connected to a DataSetProvider, and ClientDataSet. There is this simple process to determine the total value of purchases on an invoice. I'm encapsulating or wraping tables as DataBa...

Debugging a bit deeper, I found that: In ZAbstractDataSet.pas, there is this block of code, starting at line 677: for I := 0 to Length(FieldRefs) - 1 do begin SrcField := Delta.FieldByName(TField(FieldRefs ).FieldName); if SrcField <> nil then begin if (SrcField.DataType = ftLargeInt) and not VarIsN...

Hi, Using Delphi7-MySQL 5 ... I have this: CREATE TABLE `banco` ( `banco_id` bigint(20) NOT NULL auto_increment, `ban_numero` smallint(6) NOT NULL, `ban_nombre` varchar(80) NOT NULL, PRIMARY KEY (`banco_id`), UNIQUE KEY `ban_unq_numero` (`ban_numero`), UNIQUE KEY `ban_unq_nombre` (`ban_nombre`) ) EN...

Hi, I'm new using ZeosLib... and re-learning Delphi; I'm taking it after 6 year; previously I was using dbExpress drivers. I have Delphi 7 connected to mySQL 5. Using dbExpress, to delete a selected recrod on a dbgrid, I used to have: DataSource.DataSet.Delete; if TClientDataSet( DataSource.DataSet ...

Hi, I'm restarting to develop Delphi 7 applications, since 2001. I plan to use Zeos Lib to connect to MySQL 5 databases. I just downloaded and installed the components today. I will migrate some applications from dbExpress to Zeos Lib. I wanted to read documentation on properties and methods, to che...