Hi Calvin.
>This code fragment in the Sdtmgr.opentable procedure (line 234):
>
> case lcOrder == 'PRIMARY' and not llFreeTable
> lcOrder = dbgetprop(lcTable, 'Table', 'PrimaryKey')
> if not empty(lcOrder)
> set order to (lcOrder)
> endif not empty(lcOrder)
>
>generates an error 26 - 'Table has no index order set' when running the openalltables procedure after running the update procedure. Can anyone tell me whats going on here. Thanks.
It's likely that the index was removed as part of the update process. If the DBC and the meta data aren't in sync with each other, or if you've just tried to add a primary key to a table that has duplicate values in the key field, the index won't be created correctly. Check the return value of Update(); if it returns .F., the update process failed for some reason, and you should check oMeta.aErrorInfo for details on why it failed. Also, make sure you have the latest version of SDT (available from the Updates page of our Web site).
Doug
Previous
Next
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