Temporary Tables

[TorrediPisa]

Hello

Sometimes (in a VB project) I create a temporary mdb table on which I load the data coming from a certain process. Then I read that table by a Query for other purposes (for example a print) and eventually I delete that table.
Do you know if it is possible to create that table directly in the memory without writing it phisically on the disc?

Thank you very much for yr attention.
Regards

TdP

 

[johnwm]

Yep - use a disconnected recordset with ADO. A quick forum search in this forum and forum222 using 'disconnected recordset' should get you started

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller

 

[Ed2020]

Or would a two dimensional array do the job...?

Ed Metcalfe.

Please do not feed the trolls.....

 

[BobRodes]

<Or would a two dimensional array do the job...?

Yes, but it's slower to access. I once hypothesized, since it was a "simpler" construct, that I would get a performance bonus from a 2d array over a recordset. So, I performed an experiment, iterating through the different rows/elements. The array actually ran a little slower than the recordset.

However, it's probably less resource intensive...however, it's probably slower to set up...however...

Bob