A new problem has come up.
If I make a select such as:
def getNewLot(oForm,yr,sppk,varpk,oripk):
curnewlot= oForm.conn.getDaboCursor()
curnewlot.execute("select nextval('public.lot_seq') as nextlot,
s.speciesnum,
v.varnum, o.norigincode from public.agspecies s left join public.agvarieties
v on true left join public.agorigins o on true where s.pkid=%s and v.pkid=%s
and o.pkid=%s" % (sppk,varpk,oripk,))
a call to getfields is executed with an empty "tableName" as a parameter.
This causes a traceback in dbPostgres that comes from _storeFieldTypes() in
dCursorMixin.py
In this case "curnewlot" is a throw away temporary cursor.
--
John Fabiani
_______________________________________________
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]
