PRB: Error Message "Function Name Is Missing )" When Modifying a Remote View (260533)

SYMPTOMS

When you use the View Designer with the Case option set in the filter condition to modify a remote view, the following error message appears:

Function name is missing ).

When you use remote views that include case-dependent conditions in the filter, you need to create and modify the view programmatically.

RESOLUTION

The following code illustrates programmatic creation of remote views that use a case-dependent conditions in the filter:

CREATE SQL VIEW MyView REMOTE CONNECTION MyConn;
   AS SELECT * FROM TESTDATA!CUSTOMER Customer;
   WHERE UPPER(customer.cust_id) LIKE UPPER(?lccust_id)

MORE INFORMATION

This behavior occurs when the UPPER() function is used in the filter condition, or when the Case button is selected in the Filter tab of the View Designer.

Steps to Reproduce Behavior

Create a program file named Viewdemo.prg using the following code:

CREATE DATA TESTVIEW
CREATE CONNECTION MYCONN CONNSTRING  "DRIVER=Microsoft Visual FoxPro Driver;" + ;
   "SourceType=DBC;SourceDB=" + HOME(2) + ;
   "data\testdata.dbc;exclusive=no;backgroundfetch=no"
CREATE SQL VIEW MyView REMOTE CONNECTION MYCONN;
   AS SELECT * FROM TESTDATA!CUSTOMER CUSTOMER;
   WHERE UPPER(CUSTOMER.cust_id) LIKE ?UPPER(lccust_id)
MODIFY VIEW MyView
MODIFY VIEW MyView

Save and run the program.
When the View Designer opens for the first time, click the Filter tab and note that the Case portion of the filter condition is checked.
Press the CTRL+W keys.
Note that the following error message appears when the second MODIFY VIEW command is encountered:
Function name is missing ).