On Monday 15 December 2008 01:58:22 pm [email protected] wrote:
> You mean..."if you [don't] use it...", right? In that case, I see what you
> meant. We'll give her a shot.
>
> Thanks,
> Larry
>
> -----Original Message-----
> From: [email protected] [mailto:[email protected]] On
> Behalf Of Ed Leafe
> Sent: Monday, December 15, 2008 4:53 PM
> To: Dabo Users list
> Subject: Re: [dabo-users] again with the dup Bizobj.DataSource
>
> On Dec 15, 2008, at 3:42 PM, johnf wrote:
> > OK we'll try that. But I thought we did try in the recent past and it
> > did not work. Anyway I'll give it a try.
>
> When you tried it before you never used the 'addFrom()' method to
> tell the bizobj the actual table you want to query the data from. If you
> tell it, it uses the DataSource value as the table name, and obviously
> there are no tables by those modified names.
>
>
> -- Ed Leafe
With the following:
def afterInit(self):
self.DataSource = "public.arcadr1"
self.KeyField = "pkid"
self.addFrom("public.arcadr")
self.addField("ccustno")
self.addField("czip")
self.addField("ccountry")
self.addField("ccompany")
self.addField("cstate")
self.addField("ccontact")
self.addField("ccity")
self.addField("caddrno")
self.addField("caddr1")
self.addField("caddr2")
self.addField("cphone")
self.addField("ctaxcode")
self.addField("pkid")
self.addField("fk_arcust")
self.addField("isshipaddr")
self.addField("mnotes")
self.addField("fk_country")
self.NonUpdateFields=["pkid"]
self.ParentLinkField ="pkid"
self.LinkField = "fk_arcust"
self.FillLinkFromParent = True
self.addOrderBy("caddrno")
I get the following error from the requery()
missing FROM-clause entry for table "arcadr1"
SQL: select "ccustno",
"czip",
"ccountry",
"ccompany",
"cstate",
"ccontact",
"ccity",
"caddrno",
"caddr1",
"caddr2",
"cphone",
"ctaxcode",
"pkid",
"fk_arcust",
"isshipaddr",
"mnotes",
"fk_country"
from "public"."arcadr"
where public.arcadr1.fk_arcust = 7
order by "caddrno"
limit 1000
So from what I can determine the SQL is using the Data
Source and not the from.
--
John Fabiani
_______________________________________________
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]
