Patrick wrote:
the table would have to have the same fields as the query, presumably?
Not if you use batCopy as the Mode - it creates the table with FieldDefs
from the Query. You could potentially define a single TTable "MyTemp" whose
internal structure changes with each batCopy.
So a
query that returns other than all the fields of one table could have
problems?
If you use Mode of batAppend or batAppendUpdate then you could have a
problem. In that case you could use the TBatchMove component and use field
mappings.
Quoting Mike Osborne <[EMAIL PROTECTED]>:
>
>
> > Is there a simple way to save results of a TQuery to some Paradox or
> DBase
> > file ? Such file temporarily created anyway, but then, when query
closed,
> > file is deleted.
>
> Does batchmove work from a TQuery source?
>
>
> Yes:
> Table1.BatchMove(Query1, batCopy);
>
> batCopy will delete any previous Table1 you created.
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
