Empty Recordset creation

Dear All,

How do I go about creating an empty recordset? I wish to pass an empty recordset back to the client from my COM Component.

Is this kind of scenario would be desirable? Please explain the need to pass an empty recordset. Should I simply delete the records? Or do I manipulate the field object?

Cheers!
Abhijit

If you are using ado then you can create disconnectd recordset

dim rs as new recordset

rs.append(....) 'for creating fields

or you can use

set rs="select * from table where sonething is null",connection

What is it you are trying to do?

Thanks for replying back. I got the empty recordset done. Basically what I did was query a condition which was bound to be false.

How do you do that append fields bit?

Please point me in the right direction.

Cheers!
Abhijit :confused: