General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Oops is my face red?
I read it too quickly
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>If you have exclusive use of both tables (and both have indexes) you could set up a relationship between them.
>
>then use a scan loop to scan through your 4000 records inserting into the main table when the pkfield of the main table is empty.
>
>This of course will effectively do 4000 seeks so it may not be much of an improvement.
>
>If you do not have exclusive use then the SQL UPDATE command may be the a route to go down. You will need to use SEEK with this as well however.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>
>Mark -- he was asking about ADO. Your techniques (I think) would require dumps into cursors -- also an option, but probably adding too much overhead.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only