PRB: Error Message "Function Name Is Missing )" When Modifying a Remote View (260533)
The information in this article applies to:
- Microsoft Visual FoxPro for Windows 6.0
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)
Modification Type: | Major | Last Reviewed: | 10/15/2002 |
---|
Keywords: | kbBug kbCodeSnippet kbDatabase kbDesigner kbDSupport kbprb KB260533 |
---|
|