ODBiC Discussion Board


RE: Having Trouble Searching Memo Field, charlee, 05-11-2006

Try this for troubleshooting SQL...

by Roger Harris, May 18, 2006 12:41

Access allows a LIKE operator on memo fields (not all ODBC databases do), so that should work (without the double-quotes, as Dave pointed out). But maybe you are really executing the statement you think you are, or maybe an ODBC error is being returned. After the statement, add a line of HTML that just prints out $sql_statement$ to see the executed SQL with all variables resolved, and $sql_error$ to see any ODBC errors returned.


Replies:


Post Your Reply:

Name   
E-mail  optional
Topic  
Message:

HTTP Link: 
Link text: 

          


Copyright ©1997-2003, Roger Harris. All rights reserved.