Hard crashing due to fields not specified in SQL

[Ivan Smahin]

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.

> Everytime my app tried to execute this SQL, I would get a hard
> crash on the Mac.  No exception processing, just a friendly message
> from OS X that my app is gone.   In the Valentina log, this SQL is
> the last thing in the file with no return object.  

Could you send me the crash-log?

> I tried the same SQL in VStudio.  No problem - works like a charm!
Strange.






-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com