Query a Saved Recordset

[RichardF]

Hi,

Is there a way to query data from a saved recordset ?

ie.

~ in the office ~

rspeople.open "select id, name, age from people"
rspeople.save cfile, adPersistADTG

~ later ~ on a remote machine ~

rspeople.open cfile
rsnew.open "select id from rspeople where name = 'Richard'"
^^^^^^^^ ???

 

[mymou]

Don't think you can query a recordset, persisted or otherwise.

Might be best to write the file out in a format that you can query (temp table or something).


Stew