HOW TO: Understanding the different JOIN types in Servoy 3.5

Find out how to get things done with Servoy. Post how YOU get things done with Servoy

HOW TO: Understanding the different JOIN types in Servoy 3.5

Postby sbutler » Tue Apr 24, 2007 11:57 pm

To help clear up some confusion, I have made a diagram showing the different JOIN types supported in Servoy 3.5. Hope this helps.

Image
Scott Butler
iTech Professionals, Inc.
SAN Partner

Servoy Consulting & Development
Servoy University- Training Videos
Servoy Components- Plugins, Beans, and Web Components
Servoy Guy- Tips & Resources
ServoyForge- Open Source Components
User avatar
sbutler
Servoy Expert
 
Posts: 759
Joined: Sun Jan 08, 2006 7:15 am
Location: Cincinnati, OH

Postby amcgilly » Fri Jun 15, 2007 12:20 am

I haven't played with outer joins in 3.5 yet but I have this question:

Let's say you use an outer join to create a foundset and some of the columns are empty because there was no matching record in a related table. And let's say you display the foundset in a form where those empty columns are editable. That would put Servoy in a situation that makes no sense (i.e. editing db columns that don't exist). What will Servoy do if you let a user edit those non-existent columns? Is there some built-in protection against that or is it just up to the Servoy developer to be careful to avoid it?
Adrian McGilly
Servoy Developer

Image
amcgilly
 
Posts: 375
Joined: Fri Dec 09, 2005 12:03 am
Location: San Francisco, CA


Return to How To

Who is online

Users browsing this forum: No registered users and 8 guests