Hi, I'm using: ----------
- W98 - MySql ODBC (MyODBC-3.51.04.exe) / Tried also (myodbc-2.50.39-win95.zip) - Application with Centura Team Developer CTD 1.5.1 PTF6 (Gupta Sqlwindows) - MySql Server on Linux 3.23.48-19, (from Suse Linux 8.0) Problem: -------- Using bind variable in select statement in where clause get's no result. Examples (Centura Application Code) - NOT WORKING: Set sKKey = '4711' Set sSel = 'SELECT PARAM, TEXT FROM KONFIG INTO :sParam1, :sParm2 WHERE KKEY = :sKKey' Call SqlPrepareAndExecute( hSqlA, sSel ) Call SqlFetchNext( hSqlA, nErr ) Gets no Result. Don't using bind variable in where clause - WORKING: Set sSel = 'SELECT PARAM, TEXT FROM KONFIG INTO :sParam1, :sParm2 WHERE KKEY = \'4711\' I've searched many hours in newsgroups and mailing list but I can't find a solution! Thank you for help! -- Best regards Peter mailto:Peter.Franz.muc@;web.de --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
