Indexes : creating indexes after using Batchmove(batcopy)

Raf Paredis

Delphi Developer

Sat, 10 Feb 2001 03:00:00 GMT

Indexes : creating indexes after using Batchmove(batcopy)

Hello,

I'm using a Batchmove to create a copy of a table. The problem is that the
indexes are not created in the new table. (Batchmove does not copy meta data
like indexes,etc when using batCopy). How do I copy the index definitions to
the new data and make sure the index exists and is valid ????

Thank you,

Raf Paredis

Brian Bushay Tea

Delphi Developer

Sun, 11 Feb 2001 03:00:00 GMT

Re:Indexes : creating indexes after using Batchmove(batcopy)

Quote

>I'm using a Batchmove to create a copy of a table. The problem is that the
>indexes are not created in the new table. (Batchmove does not copy meta data
>like indexes,etc when using batCopy). How do I copy the index definitions to
>the new data and make sure the index exists and is valid ????

Use dbiCopyTable instead of a batch move
There is an example in BDE32.hlp

--
Brian Bushay (TeamB)
Bbus...@DataGuidance.com

Other Threads

1. Index - Creating new MDX index without previous index to copy

2. Batchmove.mode := batCopy to create new table.

3. batchmove and indexes: cannot recreate indexes based on original table

4. D1: Problem with creating indexes after BatchMove

5. Create index of Paradox table -- Table is not indexed

6. Create index of Paradox table -- always index is out of date

7. Using RDB$Indices to see if an index is ASC or DESC

8. Batchmove (batCopy-table) problem !!!

9. Why Won't BatchMove (batCopy) Make True Copies of Files

10. BatCopy problem with batchmove