CREATE TABLE UnitCategory
(
"ID" integer NOT NULL,
"Name" text NOT NULL,
"Description" text,
CONSTRAINT "UnitCategory_pkey" PRIMARY KEY ("ID"),
CONSTRAINT "UnitCategory_Name_key" UNIQUE ("Name")
)
WITHOUT OIDS;
ALTER TABLE unitcategory OWNER TO skyline;
The connection was defined with the CxnEditor. Dabo connected with
the database just fine. I opened up the CD to grab the BizObj code
created by the "Add Controls to Data Environment" wizard.
On 6/14/07, Ed Leafe <[EMAIL PROTECTED]> wrote:
> On Jun 13, 2007, at 11:51 PM, Nate Lowrie wrote:
>
> >>> So, John and I tracked down the error. I had named the table
> >>> UnitCategory and the CD is trying to access unitcategory. Somewhere
> >>> in the translation the table name is getting converted to lower
> >>> case.
> >>
> >> Oh, *man*! I thought our lower()ing days were done at like 0.5... ;(
> >
> > When I changed the table names to all lower cases, it worked fine.
> > So, it's either the Psycopg2 package or the CD.
>
> Can you please send me your CREATE TABLE statement? I want to try to
> reproduce the problem. Also, how did you define the connection? Did
> you use the CxnEditor, or the AppWizard, or do it manually?
>
> -- Ed Leafe
> -- http://leafe.com
> -- http://dabodev.com
>
>
>
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message: http://leafe.com/archives/byMID/dabo-dev/[EMAIL PROTECTED]
