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
