Join Table Sytax help needed

Reply

markmcgookin Posted: 07-06-2007 7:00 AM

rated by 0 users

Hi there, I am creating a c# mobile app and am using ES to create a query to join two tables (via a join table)

This is my code (table collection names are correct, and RouteIDNo is a Guid from above on the form and exists in the join table, against a valid Guid which SHOULD be pointing to the final table:

tblCurtailmentPointsCollection1.QueryReset();
                                
tblCurtailmentPointsCollection1.Query.Select(tblCurtailmentPointsCollection1.Query.CurtailmentPointID, tblCurtailmentPointsCollection1.Query.LongName);
                                
tblCurtailmentPointsCollection1.Query.Where(tblJoinCurtailmentPointsRoutesCollection1.Query.RouteID == RouteIDNo, tblJoinCurtailmentPointsRoutesCollection1.Query.CurtailmentPointID == tblCurtailmentPointsCollection1.Query.CurtailmentPointID);
                                
tblCurtailmentPointsCollection1.Query.Load();

I think I am just making a mistake with the syntax of the WHERE aspect, I keep getting a "Key not found exception unhandled" error

Some help would REALLY be appreciated as this is due yesterday! AH!

Cheers folks,

Mark 

Reply

Mike.Griffin replied on 07-06-2007 7:02 AM

rated by 0 users

EntitySpaces doesn't create joins on the fly through it's Dynamic Query API, however, there are many ways to do the same thing, tell us what you are trying to do, just bring back a few columns for diplay purposes, please elaborate a little and we can show you exactly how to do it.