>>>> 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.
> the table would have to have the same fields as the query,
> presumably? So a query that returns other than all the fields
> of one table could have problems?
Why would that be a problem... I always assumed that was one
of the strengths that it could duplicate a tdataset by using the
TFieldDefs of that dataset rather than the source of the data
itself... It means being able to make a table that is the result
of a join or even an outer join... It could be quite beneficial when
restructuring a database... I'm uncertain however as to how you
would then deal with assigning primary keys and autoincrement
properties to a batch moved table if you wanted them - I suspect
you get deep in DBIAlterTable (probably not the exact name of
the BDE call) territory...
--
Aaron Scott-Boddendijk
Jump Productions
(07) 838-3371 Voice
(07) 838-3372 Fax
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
