Get it working from VFP first (into SQL Table). Use Insert Into or Update instead of Append (you can test it on your VFP tables).


>Hi,
>I have a VFP app that updates the data in MS Graph 8.0 that is embedded in the general field of a VFP table.
>
>I need to do the same in a Visual Basic app, using a SQL Server table (the MS Graph object in the image field works ). I have an OLEBound control on my VB app bound to the image field in the ADO Recordset. It displays the Graph fine.
>Crystal Reports will also print the graph.
>
>But how do I programmatically update the data in the graph ?
>
>
>VFP code that works:
>strData = "SERIES1" + chr(9) + "SERIES2" + chr(13) + ;
> "Jan" + chr(9) + "25" + chr(13) + ;
> "Feb" + chr(9) + "29" + char(13)
>
>APPEND GENERAL general_field DATA strData
>
>thanks