This is the place to post technical queries about SQL Yoga
Moderators: heatherlaine, Klaus, FourthWorld, robinmiller, trevordevore
- Posts: 24
- Joined: Mon May 09, 2016 10:53 am
This is a bit perplexing for me so hopefully I am just being short sighted here but I have 3 tables.
poheader (purchase order header)
podetail (purchase order detail)
I have defined relationships between the poheader and podetail tables as well as a relationship between the products and the podetail table but there is no direct link between products and poheader table. When I populate data for the grid:
Code: Select all
put sqlquery_createObject("poheader") into theQueryA
sqlquery_set theQueryA, "related table joins", "LEFT OUTER JOIN suppliers, LEFT OUTER JOIN podetail, LEFT OUTER JOIN products"
## Specify how results should be sorted
sqlquery_set theQueryA, "order by", "poheader.poh_ID"
sqlquery_set theQueryA, "conditions", theConditions
It never returns any data for the products so my column for product name will be blank. I would appreciate a hint at where I am going wrong.
- VIP Livecode Opensource Backer
- Posts: 882
- Joined: Sat Apr 08, 2006 3:06 pm
- Location: Overland Park, Kansas
@nrprioleau - I'm sorry I never responded to this. I am set up to receive notifications when posts are made to this forum but no notification was sent. Did you every resolve this issue?
ScreenSteps - http://www.screensteps.com
Levure Application Framework: https://github.com/trevordevore/levure
LiveCode Resources for Developers: http://livecode.bluemangolearning.com