Now, if you have another table in the same database, edit one, and then select from another, MapInfo will automatically trigger a rebuild of the indices. I am not sure what is causing the index rebuild in your case, but you not only have to look for what is happening to the table you are working on, but also other tables in the same database.
I have for various purposes, closed all other tables from the same database, or deleted indices from all tables and rebuilt them after the edits.
hope this helps.
r
On Wed, 7 Apr 2004 10:43:54 +0100, Dominic Lowe <[EMAIL PROTECTED]> wrote:
Hi all,
Has anyone encountered the following problem?
Using Mapbasic I'm trying to add and populate a couple of X,Y columns to a
table that is stored in Access.
The size of this table may vary, but on a large (ish) table (> 20,000 rows)
I often get this error
"Cannot create an index on a currently edited table. Unable to create index."
All I am doing is this:
Alter Table "MyTable" ( add XCoord Float,YCoord Float ) Commit Table MyTable
Update MyTable Set XCoord = CentroidX(obj), YCoord = CentroidY(obj)
Commit Table MyTable
The strange things about this error are:
It doesn't always happen. Nobody else or any other process is accessing the Access table. Performing the same operation manually works fine. Cutting and pasting the code into the mapbasic window works fine.
This problem only occurs in a compiled mbx, and even then only sometimes..
Any thoughts? I have tried committing and not committing the table at
various points but the error still occurs. I've tried fastedit on/off to no
avail.
Cheers
Dominic
--
Robert Crossley Agtrix P/L 9 Short St PO Box 63 New Brighton 2483 Far Southern Queensland AUSTRALIA
153.549004 E 28.517344 S
P: 02 6680 1309 F: New Connection M: 0419 718 642 E: [EMAIL PROTECTED] W: www.agtrix.com W: www.wotzhere.com
--------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11302
