Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Equivalent of APPEND GENERAL DATA in VB ?
Message
De
08/08/2001 11:24:10
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Contrôles ActiveX en VFP
Divers
Thread ID:
00541102
Message ID:
00541316
Vues:
18
>#1. I am not trying to insert or update a record. I am trying to update the data inside of a chart object that is inside the image field of a SQLServer table
>
>#2. According to:
>http://support.microsoft.com/support/kb/articles/Q191/1/03.asp,
>
>"The OLE Container Control is not designed to work with the ADO Data Control"
>
>So I cannot bind the data.
>
>I tried this code, but this does not work:
>
> dim ch as Graph.Chart
>
> ' this is without bound control
> set ch = rs.fields("my_general_field").value
>
>However, adLongVarBinary will not go into the object ! But the same field does show up in Crystal Reports as a graph !
>
>
>However, if I could only get the above line to work, I can continue with the following (I know this part works - when I am not using ADO to populate the chart object):
>
> ch.Application.DataSheet.Range("A0") = "SERIES1"
> ch.Application.DataSheet.Range("B0") = "SERIES2"
> ch.application.datasheet.("01") = "Jan"
> ch.application.datasheet.("02") = "Feb"
> ch.application.datasheet.("A1") = 25
> ch.application.datasheet.("B1") = 29
>
>
>' with a bound control, this should be the code, but as I said before, ADO and OLEBound dont mix:
> set OLE1.object = rs.fields("my_general_field").value

You probably need to save the image to a file and then open it with the bound control. See the following KB article on how to do that: http://support.microsoft.com/support/kb/articles/Q258/0/38.ASP
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform