llblgen v2.6 dotnet 2.0

Hi In database it is possible to write a sql query joining the 2 tables together without having to have PK-FK relationship.

For instance:

Employee Name DOB

Visitor Name DateOfVisit select employee.name, employee.dob from employee join visitor on employee.name = visitor.name where DateOfVisit='01/01/2008'

I cannot build this using RelationPredicateBucket because there's no Visitor-to-Employee-relationship since there's no PK/FK relationship exists in the table. I also cannot create a custom relations because there's no PK nor FK defined in the employee and visitor tables

QUESTION: How to I achieve such query using llblgen. I don't want to do 2 queries, 1 is to query the visitor to get the name then query the employee to get the employee info.

Thanks

BZ

Yep, perfectly possible Please see this thread

MTrinder

The link you gave is the home page of the forum. Could you please give the correct link.

Thanks

Interesting - it works fine for me

It's pointing here

http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=14721

Neither link works for me.

Sorry, my fault - it's in the secure help desk so only the thread starter can see it.

You have two options.

You can specify the relation in the designer, even if the tables do not have a PK-FK relationship in the database

http://www.llblgen.com/documentation/2.6/Using%20the%20designer/designer_customrelations.htm

or you can specify them in code at run time

http://www.llblgen.com/documentation/2.6/Using%20the%20generated%20code/gencode_derivedtabledynamicrelation.htm

Matt

MTrinder

I already looked at the first approach and using the designer approach you mentioned would not work because there is NO PK defined in any of the tables at all.

The second approach is in program. I will take a look at it and let's see how that works out.

If there's no PK, the only option you have is through a dynamicrelation created in code.