Is there a way to convert the (readonly because of complex sql statement)
result set received from tquery.open to a paradox table so that I can write
to this table ?

Thanks in advance
J. van Tilburg
The Netherlands

On Tue, 29 Feb 2000 19:23:03 +0100, "J. van Tilburg"

One way would be to use the BDE API function DbiMakePermanent.

  DbiMakePermanent(Query1.Handle, 'new.db', True);

BDE API functions are documented in the BDE online help, BDE32.HLP,
found in the main BDE directory. To make a direct call to a BDE API
function from a Delphi unit, the BDE wrapper unit named "BDE" must be
named in the unit's Uses section.

Another way would be to use a TBatchmove component to copy the data
from (read-only) TQuery to a table (through a TTable).

And still another way to accommodate a situation like this is by
enabling cached updates and providing one update object (usually
TUpdateSQL) for each base table to be updated.

===========================================================
Steve Koterski
Technical Publications
Borland