LOCAL oConn as "adodb.connection" LOCAL oCmd as "adodb.command" LOCAL oRs as "adodb.recordset" oConn = CREATEOBJECT("adodb.connection") oConn.ConnectionString = 'Provider=VFPOLEDB.1;; Data Source="C:\Teste\TesteG\Dados\Data1.dbc";Password="";Collating Sequence=MACHINE' oConn.Open oRs = CREATEOBJECT("ADODB.Recordset") oRs.Open ("Select TOP 10 ORDERS.ORDER_NET FROM orders ORDER BY order_id",oConn) ThisForm.Olecontrol1.Series(0).Clear ThisForm.olecontrol1.Series(0).DataSource = oRS && Problem in this line ThisForm.olecontrol1.Series(0).asBar ThisForm.olecontrol1.Series(0).YValues.ValueSource = oRS.Fields("ORDER_NET").ValueI get this error message when trying to define the Datasource
Working with ADO Datasources says: syntax for Series DataSource may be a Recordset or a DSN as a string or with an externally created Recordset: Set Conn = CreateObject("ADODB.Connection") Set rst = CreateObject("ADODB.Recordset") Conn.Open "DSN=TeeChart Pro Database" rst.Open "select * from employee", Conn, 1, 1 TChart1.Series(1).DataSource = rstDoes someone uses Teechart with VFP and could show how to define a External Recordset using Teechart OCX.