=?UTF-8?B?SmFjZWsgS2HFgnVja2k=?= wrote: > Użytkownik OKB (not okblacke) napisaÅ: >> I tracked down the source of the problem. The issue is >> that >> dCursorMixin uses DataStructure to determine whether the given >> column is valid for a sort. The DataStructure code, in turn, >> relies on the BackendObject's getStructureDescription method. But >> this method uses something called getStructureOnlySQL, and that >> uses getSQL --- bypassing the UserSQL. The result is that, even >> when UserSQL is specified, the cursor tries to get the >> DataStructure by using the auto-generated SQL. This fails when >> custom SQL returns different columns than are present in the >> table, since then the actual results don't match the "structure- >> only" description. > Hi. > I guess that if you define your dBizobj.DataStructure manually in > the class initProperties method, then everything should works fine. > Try to do this.
Yeah, that's actually what I wound up doing. But it would still be good if there were a way to refresh this from the DB. The only way I could figure out the format that DataStructure wanted was by getting the real one from the DB and copy-and-pasting it. The documentation lists the six elements that the tuple is supposed to contain, but doesn't explain them (e.g., what is "data type code"?). -- --OKB (not okblacke) Brendan Barnwell "Do not follow where the path may lead. Go, instead, where there is no path, and leave a trail." --author unknown
_______________________________________________ Post Messages to: Dabo-users@leafe.com 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/Xns9F3A74E992F3OKB@80.91.229.10