DOCUMENT:Q137315  12-FEB-2000  [foxpro]
TITLE   :PRB: APPEND GENERAL DATA Not Working in Windows for Workgroups
PRODUCT :Microsoft FoxPro
PROD/VER:WINDOWS:3.0,3.0b
OPER/SYS:
KEYWORDS:

======================================================================
-------------------------------------------------------------------------------
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 query words: VFoxWin

======================================================================
Keywords          :  
Technology        : kbVFPsearch kbAudDeveloper kbVFP300 kbVFP300b
Version           : WINDOWS:3.0,3.0b

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

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.

Copyright Microsoft Corporation 2000.