Zeoslib Portal

Set CachedUpdates to False, if not, make sure to call ApplyUpdates method after Post.

Mark is right, autocommit is intended to immediately commit after each statement, regarding ExecSQL or Executed (TSQLProcessor). So it's not a bug. If we are talking about inserting, editing or deleting data in dataset, ApplyUpdates is required only if CachedUpdates is True, regardless AutoCommit is...

Try to reset your such properties, and run again.
Make sure that the first thing you do is setting sorttype property,
then sortedfields.

Hi All, Currently, SortedFields triggers the values of both IndexFieldNames and SortType. The IndexFieldNames and SortType depend each other, and it is actually a circular reference. The value of SortType depends upon the value of IndexFieldNames and then SortType triggers the value of IndexFieldNam...

Hi AHUser.

the problem you mentioned comes from MySQL it self, not from Zeoslib.
Please read MySQL manual regarding the foloat and double type.
MySQL AB recognized about the problem

currently, the only solution of the problem is changing the float type
to double type in your each table.

Regards.

Hi pawelsel, All problem so far was revised and completely solved. Revision only made in GetSortType procedure. Previously : if (Pos(' ASC',UpperCase(FIndexFieldNames))>0) and (Pos(' DESC',UpperCase(FIndexFieldNames))>0) then Result:=stIgnored else if Pos(' ASC',UpperCase(FIndexFieldNames))>0 then R...

Oh..... I think that's not proper solution.
In your case, you use Post method and not ApplyUpdates.
why you revise ApplyUpdates method?

Post method does not call ApplyUpdates,
while ApplyUpdates calls (some thime, if dataset being edited or inserted)
Post method.

Regards

method InternalSort if FIndexFieldNames = '' then exit; {bangfauzan addition} Why if dataset do not have index - do not sort? Correction : In the current version 6.6.0 beta, IndexFieldNames does not relate to the Index, but for sorting only. Becouse the old IndexFieldNames (as you mean) was replace...

Before this revision, SortType has only 2 values (stAscending and stDescending). So, consistent with that, all field on the SortedFields can be sorted ascending only or descending only. Now, I add new value into SortType named stIgnored, means that SortType being Ignored and we can sort each field i...

Currently, sorting two or more fields with different sort method (asc on one field and desc on the others) doesnt work. becouse order method handled by SortType property which we can sort asc only or desc only over all of fields defined in SortedFields. obviously, it is a bug. and I will try to rewo...

If I use Zeos 6.6.0 beta on delphi 7 "Protocol" of ZConnection is in the list so I can simply select the protocol from the list. But, if use it on BDS 2006 the list of supported protocol was disappear.
Is it a bug?

Regards

As far as I know, currently the property able only sorting one or more fields in one order method (asc only or desc only).
If you want to sort 2 fields in different order, the only way is by sql script.

regards.

and, the big problem, a while not query.eof construction became an infinite loop. I used this component (6.6.0 beta) in production environment, and everythink ok. Here an example based on your cases. Using Mysql 5 I also attach the database script (contoh.sql). No problem at all. can u send me the ...

Hi, gto The purpose of the new IndexFieldNames is for sorting only, as combination of the new behavior of SortedFieldNames and SortType. If u converted from BDE that use IndexFieldNames, you now can use LinkedFields (as master detail relationship). LinkedFields has the same behavior as old IndexFiel...

Hi Jay.... how about using "mysql-4.1" protocol on the conncetion component ? it will be automatically load libmysql41.dll which is compatible with mysql40. or you can choose "mysql" of protocol, and then (as tohenk's advices) specify the connection properties to be somethink lik...