>I am trying to open a table programmatically and it keeps telling the table has no order set. If I open by the command line it works fine. The index is there and I can set the order to. But if I put this code in a program I get Table has no order set. Here is my code:
>
>
>
>IF !USED("cmscomp")
> USE CMSCOMP IN 0 ALIAS CMSCOMP ORDER ARTIKEY
>ENDIF
>
>
>Any suggestions why this is this case
Check if you have the table with the same name but w/o CDX somewhere else in current path of your application.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.