Thank you, but no need to send you the database.

I have fixed my problems WITHOUT NumAuto field, and without changing
anything into the database structure.

Instead Of registering the database with "Register Table Connection ODBC"
...., I use Server_Connect, Server_Execute etc...and by this way there are
no problems at all.

I have however a little problem : there are some tables into the databse
with space character into the name. For example : "Table one"
How could i make requests to these tables ?

Server_Execute(databaseHandle, "Select * From Table one")
don't work, of course
Server_Execute(databaseHandle, "Select * From 'Table one'")
don't work
Server_Execute(databaseHandle, "Select * From \"Table one\"")   don't work
Server_Execute(databaseHandle, "Select * From \'Table one\'")   don't work

Thank you for your help and your patience

Chris

-----Message d'origine-----
De : Ian Hull [mailto:[EMAIL PROTECTED] 
Envoy� : vendredi 28 janvier 2005 12:33
� : Christophe Brabant
Objet : RE : RE : MI-L Querying ACCESS database with MapInfo 7.8



Christophe,

I have managed it without a auto num field. If you like you could send me
your database (or a bit of it) and I could have a quick look at it for you.

Regards,

Ian Hull


Greater Manchester Transportation Unit
Salisbury House
Granby Row
Manchester
M1 7AH

Tel:      0161 455 2059
Fax:      0161 455 2071
E-mail:   [EMAIL PROTECTED]
Website:  http://www.agma.gov.uk/Units/TransportUnit.htm




**********************************************************************
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

Please contact [EMAIL PROTECTED] with any
queries
**********************************************************************


---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 15049

Reply via email to