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.


Post Your Reply:

E-mail  optional

HTTP Link: 
Link text: 


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