Remote View upper & ucase problem

[gringoloco]

I am using the view designer to create a remote view. The view
contains name/address details. I want to set up a view parameter on the surname that is case insensitive.

In the view filter I have a line

upper(customers.csurname) like upper(?vp_surname)

The view designer is converting this to:

{fn ucase(customers.csurname} like {fn ucase(?vp_surname)}

The odbc/database do not like this! (Database is interbase 6)
Foxpro version is 6.

Can I stop the view designer doing this?

 

[Mike Lewis]

Grincoloco,

With many back ends, the query will be case-insensitive by default, so you won't need to take any special action. I don't know if that's true for Interbase, but you should be able to run a sample query to find out.

If not, check the Interbase documentation for the syntax. You will probably have to code the filter in the specific syntax of the server, rather than having VFP try to convert it for you.

Mike

Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com

 

[JRB-Bldr]

Like Mike says I have found many instances where the backend of an ODBC connection will not support everything that you are used to VFP supporting.

In those instances you will either need to create backend-resident procedures to get what you need and then execute them from within your VFP application.

Or you can get more data than you really need by not expecting record limitations that are not supported and then eliminate the un-desired records afterwards within your VFP Remote View after the initial Query has completed.

Good Luck,
JRB-Bldr

 

[gringoloco]

In the end I have solved my particular problem by using the freeware eview view edit utility to adjust the SQL after designing it in the standard view designer.

Thanks for your suggestions.