General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL Statement causes foxpro error
Hi,
I have a edit box on a form. User types in information and then clicks a search button. code looks like this:
lcSql = "select * from table where upper(fieldname) like '%" + UPPER(lcDescrip) + "%' into cursor myCursor"
&lcSql
IF the user presses the "enter" key in the edit box we get an error message, critical error 36. I think the problem is that foxpro doesn't like the upper function and the return key. Only problem is that I want this to be a case insensitive search. Any ideas on how to fix this?
Using VFP 7, sp1
Thanks!
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only