always mak a new select

always mak a new select

Postby aspirany » Mon 04 Sep 2006 16:58

I used MVS 2005 with mysqldirect .NET 3.5

mysql table (InnoDB) and when a make a select,generate an another select like:SHOW TABLE STATUS FROM ..... why?

thanks your help!
aspirany
 
Posts: 12
Joined: Mon 04 Sep 2006 16:51

Postby Serious » Tue 05 Sep 2006 05:30

Second query is used to obtain autoincrement column status.
Serious
 

Postby aspirany » Tue 05 Sep 2006 06:29

Thank a lot your fast answer. I have another question , can i turn off the secound select ?
aspirany
 
Posts: 12
Joined: Mon 04 Sep 2006 16:51

Postby Alexey » Tue 05 Sep 2006 06:57

No, you can't turn it off. But you can avoid using of DataAdapter.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for MySQL