More on this oddity: I backed-up the table concerned and created a new DATABASE with it - single table, nothing else in the way - still failed the "sort by 2" clause.
Took out the computation (concatenation) on the Full_Name column, then deleted rows a half (approx) of the total (33,000+) at a time - still no luck so not a size problem. Recreated the test DB again and removed all the constraints and indexes - it worked! Started putting the constraints back one by one... worked until a unique constraint put on the computed column. So with Full_Name computed or text and a unique constraint the "sort by 2" clause fails. "Sort by 2,1" seems to work all the time. Fun, eh? Regards, Alastair. ----- Original Message ----- From: "Alastair Burr" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 20, 2002 11:38 PM Subject: Re: Sort by function question > Thanks, everyone, for your replies. > > This gets even more interesting: > > As some of you said it worked for you I created a new database, new table, > populated a dozen rows with varying length data and - lo and behold - it > worked for me, too! > > I then went straight back to my original database and tried again and it > failed. > > The original DB is reloaded regularly and I keep a reloaded copy > separately - this also failed. > > Anybody care to offer any explanation?? > > Regards, Alastair. > > > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
