Ado works

[dickylam]

I am getting trouble in using ado, even though I read the section in MSDN, but no example for VFP, if read the jump start for VFP, only little help available...


For example, I want to use the find method available ADO, but I always get OLE IDispatch.... which is telling me VFP do not understand the parmeters I put in the find method, I think.

Like the find method, many methods and properties are seems not supported in VFP, one more example, recordcount should give the total record, but if I issue:-

? testobject.recordcount

where testobject is built via ado.recordset, the result will show -1 only.

Anybody have idea how to use ADO in depth to access the database and tables, here I use SQL 2000 server, but I think same method can use even foxpro table!

Thanks at all.

 

[rgbean]

Once you've created an object in VFP, there should be very little difference in the syntax of objects. This is one time when using VFP 7.0's Intellisense can be quite useful, especially if you haven't taken the time to locate the object model for ADO at MSDN. (Perhaps if you are using 5.0 or 6.0, you can get the 8.0 Beta and do some "free" exploring for the next month and a half.)

There are other articles on the VFP site which do give ADO sample code (other than "ADO Jumpstart for Visual FoxPro Developers" - John Petersen).

Rick