Dear All,


While using ADOConnection we face a problem when we try to Access a Table with Foreign Key

We are Getting error message when we make Connected = True

"Multiple Step Operation Generation Errors , Check Each State Values"

We are using

FrontEnd : Delphi 7.0

Backend : MYSQL 5.0.13 version.

provider : Microsoft OLE DB Provider for OBDC,

Driver :MYSQL ODBC 3.51 Driver.

ADOConnection Cursor Location : clUSeClient / ClUSeServer
ADoTable Cursor Location : clUSeClient / ClUSeServer
ADoTable Cursor Type : ctKeySet or of any Type

Kindly let us know what settings to make when we are accessing table with foriegn key.


Thanks in Advance , your suggestion is very much appericiated.

Rgds

Balu