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.

Kind Regards,


Robert.