Zeoslib Portal

Thank you !!!

Hi Mark,
I posted my first bug report: http://zeosbugs.firmos.at/view.php?id=171
I hope my description is enough clear.

Thanks,
David

Hi Mark, thank for this quick answer. I use the version "6.6.4-stable" and after a search for "ValidateUpdateCount", I found the modification was only in ZDbcGenericResolver.pas. The PostUpdates method of TZUpdateSQL is not modified yet. (I use this purpose to check if another cl...

Hi, it should be very interesting if the TZUpdateSQL.PostUpdates method included a parameter which turn on a validation of updates. In the TZUpdateSQL.PostUpdates method, replace the usual "Statement.ExecutePrepared;" by lValidateUpdateCount := StrToBoolEx( Sender.GetStatement.GetParameter...

Hi, when I do a GetDate on a field which is null or egal to "0000-00-00", the GetDate method return me 0. 0 is not the default value for Delphi's date : DateToStr(0) -> 30/12/1899 DateToStr(-700000) -> 00/00/0000 Also this constant (-700000) is always used to define a null date in Delphi. ...

Hello,
in the latest release, the default date value is always 0.
Is there anybody that had the same problem that me:
(MySQL date value for "0000-00-00" is defined to 0 and should be -700000)

Thanks
David

I wrote a component that execute this kind of update. The source code is here: Unit hxdZConcurrentUpdate; { Modification to do ZSqlUpdate: Procedure TZUpdateSQL.PostUpdates(Sender: IZCachedResultSet; UpdateType: TZRowUpdateType; OldRowAccessor, NewRowAccessor: TZRowAccessor); if ExecuteStatement the...

I have found the problem. We can't get implementing object of interface simply in casting the interface. And it's because I couldn't access to CachedResultSet object. Here, the code that I use : // http://hallvards.blogspot.com/2004/07/hack-7-interface-to-object-in-delphi.html function GetImplementi...

Nobody to help me ?
Thanks in advance.
David

I created this function that will replace my ApplyUpdates calls : Procedure TFrmMain.ConcurrentApplyUpdates; Var lConcurrentError, B: Boolean; Begin lConcurrentError := True; While lConcurrentError Do Begin Try ZQuery1.ApplyUpdates; lConcurrentError := False; Except On E: EZSQLException Do If E.Erro...

Bonjour mdaems and cipto_kh, mdaems I didn't know this method that consist to use where clause to specify data field on update and check the UpdateCount after. Effectivly your solution is good for me and I will use it combined with LastModifiedTime. For testing, I have add modification of sandeep_c2...

Hello, I'm writing an application where user can fill record within a grid. When a certain field is filled, the record is considered for filled and locked. My application will work on a network and many users will be able to fill the same record at the same time (on differents computers). To prevent...

Hi, is it possible to change the date default value or add possibility to change it inside zdbc config because lot of controls like DevExpress use -700000 value to specify NullDate. Also DateToStr(-700000) return 00/00/0000. Currently I modified MySQLResultSet.GetDate and changed Result := 0 to Resu...

Hi, I want execute queries without use zdbo components. So, i found in Knowledge base this sample : ... Statement := MyZConnection.DbcConnection.CreateStatement; ResultSet := Statement.ExecuteQuery('SELECT * FROM MyTable'); Metadata := ResultSet.GetMetadata; ... My question is: Must I destroy object...