Mysql ZTable + Filtered + SortedFields + DBGrid problem

[mangwills]

Hi! I have a simple mysql table with two columns:

~~~~~~~~~~
CREATE TABLE test_only (
id int not null primary key auto_increment,
name varchar(50) not null
);

INSERT INTO test_only (name) VALUES ('test1'), ('test2'), ('test3'), ('test4'), ('test5');
~~~~~~~~~~

When I have ZTable/ZQuery with Filtered = True, SortedFields = 'name', and I use a DBGrid to edit the 'name' column, after posting, the record jumps unexpectedly to some other row. This does not occur when either Filtered = False or SortedFields = ''.

I'm using the latest svn testing version of zeosdbo, delphi 2006, and MySQL 5.

I'll try to look for an older version of zeos where this did not occur.

Thanks!

William Yao

[mdaems]

If you don't want this problem to disappear in the forum, please add it to the bug tracker.
It would also be helpful if you could add a small sample project (project files + data creation script + eventual instructions on how the error can be reproduced).

Mark

[mangwills]

I attached the sample project to the original post. I'll add it to the bug tracker shortly -- still waiting for the activation email from the bug tracker.

-William