Works fine with back quotes, for both table name and field name Ian, you're the best !
Thank you one more time Chris -----Message d'origine----- De : Ian Hull [mailto:[EMAIL PROTECTED] Envoy� : vendredi 28 janvier 2005 14:33 � : Christophe Brabant Objet : RE : RE : RE : MI-L Querying ACCESS database with MapInfo 7.8 My query text usually looks like this "Select * from `tab one`" Note the quote is a ` not ' or ". 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 "Christophe Brabant" <[EMAIL PROTECTED] To: "'Ian Hull'" <[EMAIL PROTECTED]> ad.etca.fr> cc: <[email protected]> Subject: RE : RE : RE : MI-L Querying ACCESS database with 28/01/2005 12:47 MapInfo 7.8 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: 15054
