>I'm having a problem wiht the new SEEK() syntax.
>
>I have a NEWID(tcTable) procedure in the stored procedures of the .DBC for my application.
>
>The NEWID() procedure is failing with error 26:Table has no index order set.
>From IF SEEK( tcTable, "system", "syskey" ) which should be explicitly setting the order and should therefore not generate this error!
>
>I can't see how it's doing this since:
> 1) the code hasn't changed in 6 months
> 2) the screen it's called from hasn't changed in 6 months
> 3) the table structires/indexes haven't changed
> 4) the error log DISP STAT to file shows the tag exists
> 5) the error log shows it's the primary key
>
> 6) it works first time !
>
>The sequence of operations is Add button click (append blank), enter some data, Save button click (taleupdate), followed by Add button click (append blank).
>
>NEWID("company") is in the default value for the primary key of the company table - which worked on the first Add and not onthe second!
>
Did you try SET ORDER before Seek to see if that works (just to isolate the problem better).