Given:
tblname (parent)
-pkid
-fullname
tblphone (child)
-pkid
-fkname (foreign key to tblname)
-phone
How do I specify the UserSQL equivalent of the following:
self.DataSource = "tblphone"
self.KeyField = "pkid"
self.LinkField = "fkname"
self.addFrom("tblphone")
self.addField("phone")
When the parent record pointer changes, the child table is requeried and I
do not know how to do the WHERE clause part.
self.DataSource = "tblphone"
self.KeyField = "pkid"
self.UserSQL = """select phone from tblphone where fkname=??????"""
My actual SQL Selects are complex and I prefer to do UserSQL rather than the
alternative line-by-line specification if at all possible.
Thanks.
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message:
http://leafe.com/archives/byMID/[email protected]
