Autoinc problem ?

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
BigJuice
Posts: 4
Joined: Fri 11 Feb 2011 14:35

Autoinc problem ?

Post by BigJuice » Thu 19 May 2011 15:13

Hi everybody,
I want to say thanks to everybody who will try to help me :D

Here is my problem :
I have 2 tables in my application :
- team
- team_employe

I add a team into my table using TMyQuery.append and post the record with TMyQuery.post
My table team_employe is linked with team (Master / Detail)
So when I post the team, I try to add an employe to this team, using team_employe.append...

Here is the problem, when I use the application on a Linux MySQL server ... everything is ok. If I look in DBMonitor ... after my insert, there are select of my detail table.
But when I use the application on a Windows MySQL Server...
After my insert in DBMonitor there is nothing and I got the error :
Could not convert variant of type (Null) into type (Int64)

The connection I use have the option : Disconnect mode "True" and Pooling "True"

Thanks,

BigJuice
Posts: 4
Joined: Fri 11 Feb 2011 14:35

Post by BigJuice » Thu 19 May 2011 17:39

I found my error... It is my query, I rebuild it and everything works!!

Sorry to everybody who takes time to read me and try to find an answer :D

Post Reply