KnowledgeBase Archive

An Archive of Early Microsoft KnowledgeBase Articles

View on GitHub

Q260533: PRB: "Function Name Is Missing )" When Modifying a Remote View

Article: Q260533
Product(s): Microsoft FoxPro
Version(s): WINDOWS:6.0
Operating System(s): 
Keyword(s): kbDatabase kbDesigner kbvfp600 kbvfp600bug KbDBFDBC kbGrpDSFox kbDSupport kbCodeSnippet
Last Modified: 23-MAY-2000

-------------------------------------------------------------------------------
The information in this article applies to:

- Microsoft Visual FoxPro for Windows, version 6.0 
-------------------------------------------------------------------------------

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
---------------------------

1. 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

2. Save and run the program.

3. 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.

4. Press the CTRL+W keys.

5. Note that the following error message appears when the second MODIFY VIEW
  command is encountered:

  Function name is missing ).

Additional query words:

======================================================================
Keywords          : kbDatabase kbDesigner kbvfp600 kbvfp600bug KbDBFDBC kbGrpDSFox kbDSupport kbCodeSnippet 
Technology        : kbVFPsearch kbAudDeveloper kbVFP600
Version           : WINDOWS:6.0
Issue type        : kbprb

=============================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.