Get data to VFP9 DB via OLEDB Provider

After establishing the OLE DB connection you have to retrieve data, so you should continue on "Retrieving Data for Cursor Adapters" part of the same help topic.

You could also test data retrieval from Command window which will help you to learn ADO techniques. More info is in the help topic "How to: Access Visual FoxPro Data in Visual Studio"

To help better you should post your code or form which does not work, so we may look what's wrong with it.

Also, does the grid works for you when displaying standard DBF data?

Capturing data from real time system called let's say XX
I didnt write code but used the builder to create the cursor adapter with SelectCmd:
select time, tag, value, timestep from xxtotal where tag = 'XXX'  AND time BETWEEN '*-4d' AND '*' and timestep = '1d'
I am using XX OLEDB Provider not FoxPro OLEDB Provider.
The SQL statement is different in XX OLEDB so when built in DataAccess tab for the cursor adapter it changes to VFP style.
The original XX OLEDB SQL statement looks like:
SELECT * from xxarchive..xxtotal where tag = 'XXX'  AND time BETWEEN '*-4d' AND '*' and timestep = '1d'
The convention for current time is '*' while '*-4d' stands for 4 days back.
I dont know if I have to stick to XX OLEDB convention or I should adapt it to VFP SQL statement.
Anyway since in the builder I cannot insert the where clause XX system triggers an error message then I add the where clause in the SelectCmd
The connection string is fine as I get successful connection.

FoxPro does not know about XX OLEDB convention so you should leave the WHERE in SelectCmd. Another option is to use your own code to retrieve data from OLE DB source instead of leting builders to do this work.

in command line I typed:
oConn = CREATEOBJECT("ADODB.Connection")
oConn.ConnectionString = "provider=xxOLEDB.1;Password='';User ID=operator;Data Source=qqxx;Persist Security Info=True"
oConn.Open

SELECT tag, time, value FROM picomp WHERE tag = '31FI50010.PV' AND BETWEEN(time,DATETIME(2010,1,1),DATETIME())

The debugger shows that the connection is open and can see the default database.
How can I point the query to the OLEDB Provider ?

That is beautiful. Im getting the data.

I haven't worked with ADO before. :)  
Now I have to scan each record and write it into a table. Is that the only way I can get the data stored into a VFP table?

Thank you
Manuela

Outstanding

Interesting... I've sent one more replay which is nowhere. At least I think I did it...

So, again.

I am also not working with ADO and I've been looking for some Fill method which seems to be unavailable in FoxPro.

To store data into a table you may loop through the record set or you may use CursorAdapter class which has CursorFill method to do this work for you.

Another option is to use ODBC driver (if available) and SQL-pass through functions to store query results directly into a cursor. If you have ODBC driver then you should look at all functions beginning with SQLxxxx (SQLCONNECT, SQLEXEC, SQLTABLES, ...)

One more note: ADO is the slowest data access available in VFP :-(