Ed Leafe wrote:
On Mar 11, 2006, at 1:56 PM, Carl Karsten wrote:

Saw this, thought someone might want to know:

Dabo Error Log: Sat Mar 11 12:27:16 2006: RowCount is 0, so storeFieldTypes() can't run as implemented.

This has come up somewhere before (maybe here?) - is there a standard way to get a "cursor structure" from a query without actually running the query? I know VFP does it by tacking on "WHERE 0=1", but that seems kludgey. do all (good) db's support some sort of prepare/pre-compile/pre-something that would give you a clue what the result was going to look like?


It depends on the dbapi adapter. MySQLdb returns the structure even without the data, but others, such as pysqlite, do not. What backend were you using?


MySQL - got that in the ZipCode Demo where zipcodes.cstateprov = 'xx'

+ python SimpleFormWithBizobj.py
Dabo Info Log: Sat Mar 11 14:34:14 2006: 0 database connection definition(s) 
loaded.
Dabo Info Log: Sat Mar 11 14:34:14 2006: User interface already set to 'wx', so dApp didn't touch it. Dabo Info Log: Sat Mar 11 14:34:14 2006: wxPython Version: 2.6.1.2pre wxGTK (unicode) (gtk2) Dabo Error Log: Sat Mar 11 14:34:36 2006: RowCount is 0, so storeFieldTypes() can't run as implemented.

^C

_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users

Reply via email to