SQL question

[Ruslan Zasukhin]

On 4/4/07 11:51 PM, "Steve Albin" <steve at steve-albin.com> wrote:

> I have the following SQL:
> 
> SELECT Sessions.dSessDate, types.cTypeName, Sessions.cCity, Sessions.nSessId
> FROM Sessions, Labels, Types
> WHERE Sessions.nLabelId =  5
> AND Sessions.SessType = Types.nId
> ORDER BY Sessions.dSessDate
> 
> This SQL worked fine in V4RB 2.5.4
> 
> 
> In V4RB 2.5.8, I get the following error:
> 
> Message: The link(s) is not found between "Types" tables.
> Err Number: 529684
> 
> I don't understand because I'm specifying  the link between Session and Types
> in the WHERE clause.  I assume this error is in relation to a bad object
> pointer link.
> 
> I fixed the SQL by adding a link between Sessions and Labels as so:
> 
> SELECT Sessions.dSessDate, types.cTypeName, Sessions.cCity, Sessions.nSessId
> FROM Sessions, Labels, Types
> WHERE Sessions.nLabelId =  5
> AND Sessions.SessType =   Types.nId
> AND Sessions.nLabelId = Labels.nId
> ORDER BY Sessions.dSessDate
> 
> 
> But, there is an object pointer link between Sessions and Labels.  It shows up
> fine when I use VStudio 2.5.4.
> 
> I have had other SQL failures of a similar nature after upgrading to 2.5.8.  I
> don't mind tightening up my SQL code to fix these, but I don't understand why
> this is not working.  Shouldn't Valentina recognize the link?  And why does it
> complain about the TYPES table when that doesn't seem to be the problem?

Yes it should.

Please add into Mantis some small db and this query.
 
> By the way, I tested this SQL in VStudio as well as my RB app and get the same
> results.  So it is not my app.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]