I am in the process of creating a DLL, in which I access a SQL server DB and get a recordset. That's all fine, but I want to be able to use this DLL with both a VB application, AND a WordPerfect 8 document (uuuugh..PerfectScript). The problem I have is, I want the results of the DB lookup to be available to both apps, so the data needs to be in a 'friendly' format, readable by both apps. I have successfully returned a disconnected recordset to the VB app, BUT I'm not sure if I can use this same technique from WordPerfect, because I'm not certain if I can create a similar Recordset object in WP (similar to a Recordset object you'd create in a VB form to hold a returned Recordset). I'm thinking I should use a series of Property arrays.

What's the recommended method for returning a recordset from a custom object, so it's available in a DLL??

Hope my confusion wasn't too confusing