Microsoft KB Archive/260533

= PRB: Error Message &quot;Function Name Is Missing )&quot; When Modifying a Remote View =

Article ID: 260533

Article Last Modified on 10/15/2002

-

APPLIES TO


 * Microsoft Visual FoxPro 6.0 Professional Edition

-



This article was previously published under Q260533



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 &quot;DRIVER=Microsoft Visual FoxPro Driver;&quot; + ; &quot;SourceType=DBC;SourceDB=&quot; + HOME(2) + ; &quot;data\testdata.dbc;exclusive=no;backgroundfetch=no&quot; 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 ).



Keywords: kbbug kbcodesnippet kbdatabase kbdesigner kbprb KB260533

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.