Page 1 of 1

NULL FieldName

Posted: Thu 11 Feb 2010 15:55
by ShaiLeTroll
I change MyDAC 3.55 to 5.90 on Delphi 7 (no Patch)
I Use MySQL 4.1.9-max (Easy PHP 1.8 )

Code: Select all

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

Posted: Mon 15 Feb 2010 08:02
by Dimon
I can not reproduce the problem.
Please make sure that you have the most recent version of MyDAC (5.90.0.55).

Posted: Mon 15 Feb 2010 09:43
by ShaiLeTroll
I use MyDAC "5.90.0.54 01-Dec-09"

Posted: Mon 15 Feb 2010 10:15
by Dimon
Please send me a complete small sample to dmitryg*devart*com to demonstrate it, including a script to create and fill the table.

Posted: Mon 15 Feb 2010 14:14
by ShaiLeTroll
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

Posted: Mon 15 Feb 2010 15:00
by Dimon
Probably, this problem was connected with MySQL server or network problems, but not with MyDAC.
If any other questions come up, please contact me.