MyQuery.Append
Posted: Fri 16 Oct 2009 04:45
Hi,
Im not sure if anyone else has the same issue but here goes...
I have a number of tables where the bulk of data transactions are appends.
To do this i use a TMyQuery. First i enter the SQL: 'Select * from '.
Then i call the TMyQuery.Append procedure and proceed to populate fields using TMYquery.Fields[0].AsString etc.
I understand that the select statement before the append statement is fetching the whole dataset, so i would like to avoid this (uneccessary network/server utilization).
Is there a way to.... instead of 'select *' to maybe 'Use ' before the append call?
Cheers
Im not sure if anyone else has the same issue but here goes...
I have a number of tables where the bulk of data transactions are appends.
To do this i use a TMyQuery. First i enter the SQL: 'Select * from '.
Then i call the TMyQuery.Append procedure and proceed to populate fields using TMYquery.Fields[0].AsString etc.
I understand that the select statement before the append statement is fetching the whole dataset, so i would like to avoid this (uneccessary network/server utilization).
Is there a way to.... instead of 'select *' to maybe 'Use ' before the append call?
Cheers
