PRB: APPEND GENERAL DATA Not Working in Windows for Workgroups

Last reviewed: December 14, 1995
Article ID: Q137315
The information in this article applies to:
  • Microsoft Visual FoxPro for Windows, versions 3.0, 3.0b

SYMPTOMS

The following command does not successfully update a general field in Windows for Workgroups but does update the general field in Windows 95.

   APPEND GENERAL fieldname DATA datastring CLASS MSGRAPH

WORKAROUND

Issue the APPEND GENERAL command a second time without the CLASS MSGRAPH, or double-click the general field to open MSGraph, which shows the correct graph.

STATUS

Microsoft is researching this behavior and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Run the following program under Windows 95 to see that general field shows the correct graph:

    CLOSE ALL CLEAR ALL CREATE TABLE grphdata (desc C(10), one N(2),two N(2), three N(2))

       FOR i=1 TO 4   && create four records and load with data
          APPEND BLANK
          REPLACE desc WITH 'test'+ALLTRIM(STR(i)),one WITH i,two ;
             WITH i+1, three WITH i+3
       ENDFOR
       * create a text file
       COPY TO testdata FIELDS desc,one,two,three DELIMITED WITH TAB
       * create a table that has a memo field to hold text file
       CREATE TABLE grapmemo (textstr m)
       APPEND BLANK
       * place headings in the memo field
       REPLACE textstr WITH ;
          "desc"+chr(9)+"one"+chr(9)+"two"+chr(9)+"three"+chr(13)+chr(10)
       * place data from the text file in the memo file
       APPEND MEMO textstr FROM testdata.txt
       graphstr= textstr   && set a variable to the contents of the memo field
       CREATE TABLE graph ( olegraph  g)
       APPEND BLANK
       * add data for graph to general field
       APPEND GENERAL olegraph DATA graphstr CLASS MSGRAPH
       MODIFY GENERAL olegraph
    
    

  2. Run the same code under Window for Workgroups. The general field shows the wrong graph. It may show a graph that was previously stored in the general field or the last graph that MSGraph created.

NOTE: Under certain environments, issuing the APPEND GENERAL command twice might not show the correct graph. Adding the following code will allow the correct graph to be displayed:

   APPEND GENERAL olegraph DATA graphstr
   USE
   USE graph
   APPEND GENERAL olegraph DATA graphstr


Additional reference words: 3.00 3.00b VFoxWin
KBCategory: kbgraphic kbprb
KBSubcategory: FxotherGraphic


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.

Last reviewed: December 14, 1995
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.