Hello:
I have just started using dabo with sqlite3. I downloaded it using
subversion on 2/11/2006.
My os is Windows XP Pro SP2. I am using
python2.4,wxPython2.6-win32-unicode-2.6.3.3-py24.exe,
pysqlite-2.3.2.win32-py2.4.exe, MySQL-python.exe-1.2.1_p2.win32-py2.4.exe and
sqlite-3.3.12.
I was not able to find an answer the following question in the archives.
I followed the screen cast, Building a Database Application using the Dabo
Class Designer
(Part 1 and Part2) with webtest.sqlite and it worked perfectly. I then used
one of my own
databases with the same screencasts. The salient sqlite3 table schema is as
follows:
create table RecName (RecID INTEGER PRIMARY KEY ON CONFLICT IGNORE
AUTOINCREMENT , Name VARCHAR(80), ext VARCHAR(30) NOT NULL DEFAULT '',
location VARCHAR(120),
Type0 INTEGER NOT NULL DEFAULT 13 , Descript VARCHAR(8000), Date0
VARCHAR(80), inFamTr INTEGER NOT NULL DEFAULT 0, RecSource VARCHAR(80),
InfSource VARCHAR(80),
StorageBox VARCHAR(60), HideOnline INTEGER NOT NULL DEFAULT 0, DifFormat
VARCHAR(250), Date_num INTEGER NOT NULL DEFAULT -1, FOREIGN KEY (Type0)
REFERENCES Category(typeID),
UNIQUE (Name, location) ON CONFLICT IGNORE);
I ran the app and all the data was displayed on the form except for the data
from
field 'Name'.
The error output was as follows:
Dabo Info Log: Mon Feb 12 20:47:52 2007: 1 database connection definition(s)
loaded.Dabo Info Log: Mon Feb 12 20:47:53 2007: PyOpenGL not present, so
dGlWindow is not loaded.Dabo Info Log: Mon Feb 12 20:47:53 2007: User
interface set to 'wx' by dApp.Dabo Info Log: Mon Feb 12 20:47:53 2007:
wxPython Version: 2.8.1.1 wxMSW (unicode)Dabo Info Log: Mon Feb 12 20:47:54
2007: WARNING: No BasePrefKey has been set for this application.Could not
delete c:\docume~1\dew\locals~1\temp\tmpix68lv.pyc: [Errno 2] No such file or
directory: 'c:\\docume~1\\dew\\locals~1\\temp\\tmpix68lv.pyc'
Dabo Info Log: Mon Feb 12 20:48:09 2007: Application finished.Traceback (most
recent call last):
File "C:\projects\dabo\lib\eventMixin.py", line 97, in raiseEvent
bindingFunction(event)
File "C:\projects\dabo\ui\uiwx\dPemMixin.py", line 1155, in __onUpdate
self.update()
File "C:\projects\dabo\ui\dDataControlMixinBase.py", line 109, in update
self.Value = method()
TypeError: 'str' object is not callable
Traceback (most recent call last):
File "C:\projects\dabo\lib\eventMixin.py", line 97, in raiseEvent
bindingFunction(event)
File "C:\projects\dabo\ui\uiwx\dPemMixin.py", line 1155, in __onUpdate
self.update()
File "C:\projects\dabo\ui\dDataControlMixinBase.py", line 109, in update
self.Value = method()
TypeError: 'str' object is not callable
/*************************************************************/
Although, I did not think the word 'Name' was a reserved word. I created
another database with the same schema and data except that the field 'Name'
was changed
to 'FName' and the app ran without problems. The data from field 'FName' was
displayed
on the form.
create table RecName (RecID INTEGER PRIMARY KEY ON CONFLICT IGNORE
AUTOINCREMENT , FName VARCHAR(80), ext VARCHAR(30) NOT NULL DEFAULT '',
location VARCHAR(120),
Type0 INTEGER NOT NULL DEFAULT 13 , Descript VARCHAR(8000), Date0
VARCHAR(80), inFamTr INTEGER NOT NULL DEFAULT 0, RecSource VARCHAR(80),
InfSource VARCHAR(80),
StorageBox VARCHAR(60), HideOnline INTEGER NOT NULL DEFAULT 0, DifFormat
VARCHAR(250), Date_num INTEGER NOT NULL DEFAULT -1, FOREIGN KEY (Type0)
REFERENCES Category(typeID),
UNIQUE (FName, location) ON CONFLICT IGNORE);
I was wondering if this is a bug or is the word 'Name' a reserved word in
Dabo ?
thanks,
dwarder
---------------------------------
Never miss an email again!
Yahoo! Toolbar alerts you the instant new Mail arrives. Check it out.
--- 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
