Hard crashing due to fields not specified in SQL

[erne]

on 6-07-2007 8:49, Ivan Smahin at IvanSmahin at public.kherson.ua wrote:

> Hello Steve,
> 
> Friday, July 6, 2007, 12:28:02 AM, you wrote:
> 
>> In my  V4RB 3.0.1 app, I had this SQL:
> 
>> Select  Issues.recid, Issues.nId, Labels.cLabelIdx
>> FROM  Issues,  Labels, Sessions, Perfs, IssPerfs
>> WHERE  Sessions.nLabelid = 301
>> AND Sessions.nSessId = Perfs.nSessId
>> AND Perfs.nPerfId = IssPerfs.nPerfId
>> AND Issues.nid = issPerfs.nIssueId
>> AND Issues.nLabelId = Labels.nId
>> AND Issues.cFormat =  32
>> ORDER BY Issues.cCatnum, Issues.cTitleIdx
> 
> I'm doubt it is able to run (never mind vStudio or some ADK )
> Currently, it's  not  allowed  to use  "order  by"  against the field which
> does not
> mentioned in SELECT clause. But it should be no crash.
> 

Strange, feature of Order by not Selected field seemed to work for me lately

I'll double check




Cool Runnings,
Erne.
-- 

/ |\ |\  | /
­ |/ | \ | ­
\ |\ |  \| \