List:General Discussion« Previous MessageNext Message »
From:Struan Bartlett Date:March 18 1999 11:20am
Subject:Access <-> MyODBC <-> MySQL problem
View as plain text  
Hi. I've an Access 97 database with MySQL (3.22.16a-gamma-log) tables
linked via MyODBC 2.50.22.

I've designed an Access Query such that the Access 'SQL View' says:

SELECT RawM.Name, * FROM RawM WHERE (((RawM.Name) Like 'MYINFOBOX%'));

However, the appropriate excerpt from the MyODBC log file says:

MSACCESS        de:aa	ENTER SQLExecDirect 
		HSTMT               0x008b24f0
		UCHAR *             0x086513d4 [      -3] "SELECT RawM.ID FROM RawM WHERE (Name =
'MYINFOBOX%' ) "
		SDWORD                    -3

MSACCESS        de:aa	EXIT  SQLExecDirect  with return code 0 (SQL_SUCCESS)
		HSTMT               0x008b24f0
		UCHAR *             0x086513d4 [      -3] "SELECT RawM.ID FROM RawM WHERE (Name =
'MYINFOBOX%' ) "
		SDWORD                    -3

MSACCESS        de:aa	ENTER SQLFetch 
		HSTMT               0x008b24f0

MSACCESS        de:aa	EXIT  SQLFetch  with return code 100 (SQL_NO_DATA_FOUND)
		HSTMT               0x008b24f0

And here's the appropriate except from the MySQL log:

990318 11:01:52    2126 Connect    struanb@stripped on newsnow
                   2126 Query      SELECT Config, nValue FROM MSysConf
                   2126 Query      SELECT RawM.ID FROM RawM WHERE (Name = 'MYINFOBOX%' ) 
990318 11:02:35    2126 Query      SELECT RawM.ID FROM RawM WHERE (Name = 'MYINFOBOX%' )

Umm?! Can anyone tell me how/why the SQL "Like" (in the original SQL
statement) been changed to an "="? And by what? Or should I post this
query to the MyODBC list? 

Thanks in advance.

Kind regards,

Struan Bartlett.

------------------------------------------------------------------
Struan Bartlett         | The Premier UK News Aggregation Web site
Managing Director       | http://www.newsnow.co.uk/
NewsNow Publishing Ltd  | Your remote control for news on the Net
                        |
Tel.  : 0171 720 2727   | "The only straight lines found
Mobile: 0958 686494     |  in nature are those drawn by us"
------------------------------------------------------------------


Thread
Access <-> MyODBC <-> MySQL problemStruan Bartlett18 Mar
  • Access <-> MyODBC <-> MySQL problemMichael Widenius18 Mar
  • RE: Access <-> MyODBC <-> MySQL problemRobert J Greene20 Mar