=?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: [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]
