Infralution Support

[MikeR]

I have a need for temporary data storage during flat file processing of import data. After file processing is completed, the temporary data is then processed through my VDO recordsets normally and so forth.

Ideally, I would like to store the data in a strongly typed virtual record subclass, however, I am finding that impossible under normal circumstances for the following reasons:

Only way to create such a record is to use AddNew() method, which requires a virtual recordset and verifies that database constraints are all being implemented.

Short of creating duplicate classes with identical properties and no database connections, do you guys see any clever way to do this using my existing strongly typed VDO classes?

Thanks.
_________________
Thanks,

-- Mike R.

[MikeR]

Typical with me after a short period of reflection (pun intended).

Since I am using a code generator to generate my strongly typed virtual datasets / VDO classes, I just extended the generator to create my temporary classes with identical property names to my VDO records. Works great, and the generic code is faster than the other way around, which makes sense, since the database interface is no longer involved in the process of caching temporary import data.

But thanks anyway.

cheers
_________________
Thanks,

-- Mike R.

[Infralution]

You are a very easy customer, in that you always solve your own problems
_________________
Infralution Support

[MikeR]

Yes, I am a cheap date

:>
_________________
Thanks,

-- Mike R.