Hi,
I'm running Dabo (0.9a rev:3308) on Win-XP with Python 25 wxPython
2.8.1.1 with a SQLite database.
I am getting problems when the bizobj requeries the database. I have
simplified the query down to a single table and get the problem with
some filter combinations but not others. I suspect the problem may be
data related and/or down in the framework. Looking at the table with
TkSQLite I cannot see any differences that might account for the problem.
When a filter combination fails, it fails every time, and a combination
that works will always work.
I show below a working query and a failing one, run on the same database
with same program.
After getting the error message, if I try to do other working queries, I
get a message 'sqlite3.OperationError: database is locked'.
Hope you can help.
Dave Nation
-----------------------------------------------------------------------------
c:\OrderBook>main
c:\OrderBook>set temp=c:\Orderbook\TEMP
c:\OrderBook>c:\python25\python main.py
dabo.settings.MDI True
Dabo Info Log: Wed Aug 15 17:42:17 2007: 1 database connection
definition(s) loa
ded.
Dabo Info Log: Wed Aug 15 17:42:17 2007: User interface already set to
'wx', so
dApp didn't touch it.
Dabo Info Log: Wed Aug 15 17:42:18 2007: wxPython Version: 2.8.1.1 wxMSW
(unicod
e)
self.Form.productBizobj.getSQL() select "Product"."ID",
"DepartmentID",
"BrandID",
"SupplierID",
"CatalogSequence",
"Description",
"SizeWeight",
"PackSize",
"OrderCode",
"PackCost",
"PackCostDate",
"PromoCost",
"SellPrice",
"RRP",
"PromotionText",
"ManufacturerCode",
"RangeFlag",
"FastSeller",
"OrderUnit",
"CreateDate",
"DiscontinuedText"
from Product
where RangeFlag = 1 and DepartmentID = 930
limit 20000
Record Count 29 *** and all is OK
c:\OrderBook>main
c:\OrderBook>set temp=c:\Orderbook\TEMP
c:\OrderBook>c:\python25\python main.py
dabo.settings.MDI True
Dabo Info Log: Wed Aug 15 17:43:54 2007: 1 database connection
definition(s) loa
ded.
Dabo Info Log: Wed Aug 15 17:43:54 2007: User interface already set to
'wx', so
dApp didn't touch it.
Dabo Info Log: Wed Aug 15 17:43:54 2007: wxPython Version: 2.8.1.1 wxMSW
(unicod
e)
self.Form.productBizobj.getSQL() select "Product"."ID",
"DepartmentID",
"BrandID",
"SupplierID",
"CatalogSequence",
"Description",
"SizeWeight",
"PackSize",
"OrderCode",
"PackCost",
"PackCostDate",
"PromoCost",
"SellPrice",
"RRP",
"PromotionText",
"ManufacturerCode",
"RangeFlag",
"FastSeller",
"OrderUnit",
"CreateDate",
"DiscontinuedText"
from Product
where RangeFlag = 0 and DepartmentID = 930
limit 20000
Dabo Error Log: Wed Aug 15 17:44:32 2007: Error fetching records: not
enough arg
uments for format string
Record Count 0
_______________________________________________
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/dabo-users/[EMAIL PROTECTED]
