General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Question VFP / SQL server
I have write a program with ADO
The program must run with VFP databases and SQL database
If i use a sql statement in sql server it is not case sentive
lSql = "SELECT * FROM RELA WHERE pers like 'DO%' or place like "AMS%'"
Recordset.open(lSql,connection,1,2)
IF i have an index on pers and place the query is very fast
Now the problem
IF i use the VFP databases
The index on pers and place are like UPPER(pers) and UPPER(place)
If i use the statement before it wil not work.
if have to use the statement
lSql = "SELECT * FROM RELA WHERE {fn UCASE(pers)}like 'DO%' or {fn UCASE(PLACE)} like "AMS%'"
Recordset.open(lSql,connection,1,2)
How can solve this
Kind regards
Jan Dorresteijn
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