We are working on an ASP web project. For some of the data retrieval, we are creating some VFP COM servers. It would be very handy to use VFP's engine to create a cursor, convert the cursor to an ADO recordset, and pass the recordset back to the ASP environment.
I noticed that the example that Microsoft provides (DBF2RS)for converting a VFP recordset to an ADO cursor simply converts memo fields to fixed-length 256-character fields. Is this useless or what?
CASE lcFieldType=="M"
lnDataTypeEnum=ADCHAR
lnFieldSize=256
Can anybody out there please reveal how to convert a VFP cursor to an ADO recordset in a way that maintains a memo field's full length and all data within it.
Is there not some "built-in" way to achieve this (i.e., provided by Microsoft) rather than having to hand-code a relatively slow VFP procedure?
Thanks very much.