Hi All:
Thanks to all your replies my project is now a VB/VFP joint development project. Since I had argued (and presented your comments) that VFP is and always will be better at handling database related events, I've some how been elected to create the database and business COM server utilities. <-- is this good or bad? Is this called the Middle Tier?
Anyway, we use MS SQL Server 7.0, VB6, & VFP6. As for accessing the SQL Server database I'll be using ADO2.0 with the VFPCOM utility.
Again, I am in need of your assistance:
After this...
LOCAL lnError
oADO = CreateOcject("vfpcom.comutil")
oRecordSet = CreateObject("adodb.recordset")
oRecordSet.Open("Select * FROM Customers",,)
lnError = oADO.RSToCursor(oRecordSet,"CustCursor")
1. How do I get the above cursor, CustCursor, into a VFP grid?
2. If the above code is reprogrammed to be a COM server code how would I pass the oRecordSet or CustCursor back to a VB program or even a VFP program?
Thanks,
Mal
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement