NULL FieldName

ShaiLeTroll · Post by **ShaiLeTroll** » Thu 11 Feb 2010 15:55

I change MyDAC 3.55 to 5.90 on Delphi 7 (no Patch)
I Use MySQL 4.1.9-max (Easy PHP 1.8 )

SELECT MAX(`id_MyTable`) + 1 AS AutoIncMinAllowedValue FROM `MyTable`

MyTable is empty table with 50 fields
id_MyTable is PRIMARY AutoINC

It Work with ADO, with Query Browser, with MyDac 3.55
I receive a Table with one Column "AutoIncMinAllowedValue" and NULL Value, it's OK

But with MyDac 5.90, the fieldname of Fields[0] is #0#0#0
I can't use FieldByName('AutoIncMinAllowedValue') !!!

I circumvented the problem with parenthesis

Code: Select all

SELECT ( MAX(`id_MyTable`) + 1 ) AS AutoIncMinAllowedValue FROM `MyTable`

With a No-Empty Table, it's work with any version

Why this changement on MyDAC Version ?

I Use this Request for Repair MyISAM AutoInc value on start-up of programs (sometimes it returns to 1 for no reason), the server run 24/24 for several months without rebooting

Accept English ou French Response

Dimon · Post by **Dimon** » Mon 15 Feb 2010 08:02

I can not reproduce the problem.
Please make sure that you have the most recent version of MyDAC (5.90.0.55).

ShaiLeTroll · Post by **ShaiLeTroll** » Mon 15 Feb 2010 09:43

I use MyDAC "5.90.0.54 01-Dec-09"

Dimon · Post by **Dimon** » Mon 15 Feb 2010 10:15

Please send me a complete small sample to dmitryg*devart*com to demonstrate it, including a script to create and fill the table.

ShaiLeTroll · Post by **ShaiLeTroll** » Mon 15 Feb 2010 14:14

I can not reproduce the problem too !
This Morning, I have not reproduce this anomaly !
Yet I have nothing changed on the server that is running since 1 January 2010
Incomprehensible!

Maybe the network problems that we had internally in society have affected my testing client \ server between MySQL 4.1.19 and MyDAC 5.90.0.54 01-Dec-09

Dimon · Post by **Dimon** » Mon 15 Feb 2010 15:00

Probably, this problem was connected with MySQL server or network problems, but not with MyDAC.
If any other questions come up, please contact me.