On Thu, Dec 11, 2008 at 7:01 PM, Ed Leafe <[email protected]> wrote:
On Dec 11, 2008, at 7:53 PM, Ifi Okoye wrote:
File "C:\Program Files\dabo\ui\dDataControlMixinBase.py", line 110, in
__dataUpdate
self.Value = method()
TypeError: 'str' object is not callable
However, the error doesn't show up when I create an application from
other
databases.
I'm creating the Dabo application using the Application wizard ...
I'm sure it has to be something to do with that particular database,
but I
have no idea what could be going on ...
Any ideas why I'm getting this error?
It looks like you have a column in your table with the same
name as a method in the bizobj.
What are the names of the columns in the table?
Here's my table declaration:
CREATE TABLE nemus_corporation(
ID integer NOT NULL AUTO_INCREMENT PRIMARY KEY,
Name varchar(50) NOT NULL,
ContactName varchar(50) NULL,
ContactTitle varchar(10) NULL,
ContactEmail varchar(75) NULL,
Website varchar(200) NULL,
Address varchar(200) NULL,
City varchar(50) NULL,
State varchar(50) NULL,
Country varchar(50) NULL,
PostalCode varchar(10)NULL,
Phone varchar(25) NULL,
Extension varchar(8) NULL,
Notes longtext NULL,
UNIQUE KEY(Name)
);
CREATE TABLE nemus_store(
ID integer NOT NULL AUTO_INCREMENT PRIMARY KEY,
Name integer NOT NULL,
Corporation_name varchar(50) NOT NULL,
ContactName varchar(50) DEFAULT 'MANAGER' NULL,
ContactTitle varchar(10) NULL,
ContactEmail varchar(75)NULL,
Website varchar(200) NULL,
Address varchar(200) NOT NULL,
City varchar(50) NOT NULL,
State varchar(50) NOT NULL,
Country varchar(50) NOT NULL,
PostalCode varchar(10) NOT NULL,
Phone varchar(25) NOT NULL,
Extension varchar(8) NULL,
Notes longtext NULL,
Foreign Key(Corporation_name) references nemus_corporation(Name),
UNIQUE KEY(Name,Corporation_name)
);
CREATE TABLE nemus_product (
ID integer NOT NULL AUTO_INCREMENT PRIMARY KEY,
Name varchar(200) NOT NULL,
Description longtext NOT NULL,
QuantityPerUnit integer NOT NULL,
UnitPrice double precision NOT NULL,
Discontinued bool NOT NULL,
UNIQUE KEY(Name)
);
CREATE TABLE nemus_order (
ID integer NOT NULL AUTO_INCREMENT PRIMARY KEY,
Corporation_name varchar(50) NOT NULL,
Store_name integer NULL,
OrderDate datetime NOT NULL,
ShipToAddress varchar(200) NOT NULL,
ShipToCity varchar(50) NOT NULL,
ShipToState varchar(50) NOT NULL,
ShipToCountry varchar(50) NOT NULL,
ShipToZipcode varchar(10) NOT NULL,
ShipToPhone varchar(25) NOT NULL,
OrderProcessed bool NOT NULL,
Foreign Key (Corporation_name) references nemus_corporation(Name),
Foreign Key (Store_name) references nemus_store(Name)
);
CREATE TABLE nemus_orderdetails (
ID integer NOT NULL AUTO_INCREMENT PRIMARY KEY,
Order_id integer NOT NULL UNIQUE,
Product_id integer NOT NULL UNIQUE,
UnitPrice double precision NOT NULL,
Quantity integer NOT NULL,
Discount double precision NULL,
ShipperName longtext NOT NULL,
ShipperPhone varchar(25) NOT NULL,
ShippedDate datetime NULL,
OrderProcessed bool NOT NULL,
Foreign Key(Order_id) references nemus_order(ID),
Foreign Key(Product_id) references nemus_product(ID),
UNIQUE KEY(Order_id, Product_id)
);
CREATE TABLE nemus_administrator (
ID integer NOT NULL AUTO_INCREMENT PRIMARY KEY,
Name varchar(50) NOT NULL,
Title varchar(10) NULL,
Address varchar(200) NOT NULL,
City varchar(50) NOT NULL,
State varchar(50) NOT NULL,
Country varchar(50) NOT NULL,
ZipCode varchar(20) NOT NULL,
Phone varchar(25) NOT NULL,
UNIQUE KEY(Name)
);
CREATE TABLE nemus_members(
ID integer NOT NULL AUTO_INCREMENT PRIMARY KEY,
Username varchar(50) NOT NULL,
Password varchar(50) NULL default 'password',
Store integer NULL default '0',
Corporation varchar(50) NOT NULL,
Foreign Key (Corporation) references nemus_corporation(Name),
Foreign Key (Store) references nemus_store(Name),
UNIQUE KEY(Username)
);
--ifi
-- Ed Leafe
--
Notice: This e-mail (including attachments) is covered by the
Electronic Communications Privacy Act, 18 U.S. C._2510-2521, is
confidential and may be privileged. If you are not the intended
recipient, please be aware that any retention, dissemination,
distribution, or copying of this communication is prohibited. Please
reply to the sender that you have received this message in error, then
delete it. If you are the intended recipient, I do NOT give you
permission to distribute the contents of this communication to anyone.
Thank you for helping to maintain privacy.
--- 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]
