>Hi!
>
>With Adodc1.Recordset
> .Fields("general_field") = strData
> .Update
>End With
>
>or even simpler:
>
>Adodc1.Recordset.Update "general_field", strData
>
>>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
But will this change only the data series or the whole field contents?
Seems to me that this code will replace the field contents with whatever is in strData, and that is not what is being pursued. But maybe I missed something?