On Dec 24, 2010, at 12:30 PM, Carey Gagnon wrote:

> None of this is proprietary Ed  ... just an app I'm trying to build to make
> my paying job easier. This is a CD developed app.


        OK, that code looks fine. Just wanted to check the obvious ("is it 
plugged in?").  :)

        The error is happening when you attempt to move the RowNumber to 0. It 
is then requerying the child to get its data structure (hence the limit 1 being 
added - we don't want to pull a ton of data; one record will show the data 
structure).

        Is there any data in the contacts bizobj at this point? If not, the FK 
param will be empty (None), and that might explain the missing parameter in the 
SQL statement.

 File "c:\docume~1\admini~1\locals~1\temp\tmpejegch.py", line 663, in
search   <------------------- For my search function, Possible issue??
   biz.RowNumber = 0
 File "C:\src\dabo\biz\dBizobj.py", line 2439, in _setRowNumber
   self.requeryAllChildren()
 File "C:\src\dabo\biz\dBizobj.py", line 1564, in requeryAllChildren
   child.requery()
 File "C:\src\dabo\biz\dBizobj.py", line 992, in requery
   oldDataStructure = self.DataStructure
 File "C:\src\dabo\biz\dBizobj.py", line 2213, in _getDataStructure
   return self._CurrentCursor.DataStructure
 File "C:\src\dabo\db\dCursorMixin.py", line 2567, in _getDataStructure
   ds = self.BackendObject.getStructureDescription(self)
 File "C:\src\dabo\db\dBackend.py", line 468, in getStructureDescription
   aux.execute(structure_only_sql)
 File "C:\src\dabo\db\dCursorMixin.py", line 367, in execute
   raise dException.DBQueryException(errMsg)



-- Ed Leafe

_______________________________________________
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]

Reply via email to