Assertion failure

[jme3]

I'me trying to do an incremental search on a field of numbers(varchar10) using % wildcard. If I start with a 2, it works. If I start with anything else, 1, 3, 7 etc. I get a "Assertion failure (D:\Projects\Delphi\Mydac\Source\MyClasses.pas, line 3972)". Useing MyDAC 4.30.0.12 and BCB5 on a table with 30,000 records. I'me a new user so maybe I'me missing something here but I'me completly confused.

[jme3]

Also if I run the equivelent query directly on the db, it works fine.?????

[swierzbicki]

The best thing to do is to supply a sample application.

[jme3]

Thanks for the reply. I will put together a simple app tomorrow. A few new observations. I upgraded to MyDAC 4.30.1.15 and am using MySQL 5.0.19 and now failure shows line 3979 in MyClasses.pas. My table in question has 31 fields, mostly varchars and ints along with 2 dates and 2 times. If I comment out the 2 time fields in my select all works as expected. If I add either one of them back it again fails. Thanks again for any help. This one is driving me nuts.

[swierzbicki]

Hello jme3,

I forgot this : with your sample application also provide an SQL Script to generate the Database + Table used in your sample.

With such infos, I'm sure that CrLab will find your bug !

[Antaeus]

jme3, unfortunately the information you have provided isn't enough. Please send us (evgeniyD*crlab*com) a complete small sample to demonstrate it, including script to create and fill table. Also supply us with exact version of Delphi, C++ Builder or Kylix.

[jme3]

Thanks again for your quick response. Will put that together today. When ready, where should I send it.

[Antaeus]

We wait for your letter to evgeniyD*crlab*com.

[Antaeus]

Thank you for sample. We have reproduced this problem and fixed it. This fix will be included in the next MyDAC build.
This bug appears in Direct mode for prepared statements when fetching time field with value that equals to '00:00:00'.

[jme3]

Thank you very much. When will that next release be.
jme3