List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:September 23 2002 3:59pm
Subject:Re: user variables in ODBC
View as plain text  
In the last episode (Sep 23), Klavs bryld said:
> It seems like MyODBC  (or ODBC in general ?) cannot accept user variables.
> The following query works OK when quering directly through the API but doesnt work
> via MyODBC
> 
> Any suggestions to some workaround allowing the use of user variables???
> 
> SELECT id, 
> @s:="<lang lang=da>",
> 
> It's testet with windows MyODBC-version 2.50.27 in an
> delphi-application using modbc-component.

You might need to make this a passthrough query.  If you don't, Windows
will process the query through its internal SQL parser, which will
definitely complain about mysql-specific features.

-- 
	Dan Nelson
	dnelson@stripped
Thread
user variables in ODBCKlavs bryld23 Sep
  • replication problemDavid Piasecki23 Sep
    • re: replication problemVictoria Reznichenko24 Sep
      • RE: replication problemDavid Piasecki24 Sep
  • Re: user variables in ODBCDan Nelson23 Sep