robert.gilland wrote:

> I have a table I ise for temporary data called FILTERSTD
>
> in it I have a primary key ( filterid, code ).
>
> I want the results of a Full text search to directly
> inject into this table.
>
> like
>
> INSERT INTO FILTERSTD
> ( FILTERID, CODE )
> SELECT 20000, FTS_RESULT.CODE
> FROM FTS_RESULT
>
> Is this possible?
>
> Currently I read the result of the found codes pump into stringlist
> then pump back into database from stringlist this seems a large waster of time to me.
>
> If I could organise the results to be directly inserted into my destination table. It would be way better. Time is of the essence.

What makes you think that it's not possible?
SQL looks perfectly valid so is there any error simply executing it?
Tib_dsql should run it fine ....

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php