Am 05.02.2011 19:49, schrieb Ed Leafe:
> On Feb 5, 2011, at 1:39 PM, Sibylle Koczian wrote:
>
>> True, but if you don't always want to get complete tables into
>> your bizobj you'd normally need parameterized SQL. The select pages
>> of AppWizard applications should contain lots of it (can't find the
>> place ATM). And this might be distributed all over the application,
>> not concentrated in bizobj methods.
>
>
> Paul's point is that if you are using the SqlBuilder methods (i.e.,
> not using UserSQL), Dabo will know the backend in use and create the
> parameters appropriately. His use case is running user-defined SQL
> statements against both SQLite (which uses ?) and MySQL (which uses
> %s).
>
Now I'm confused, because I did use SqlBuilder methods:
biz.setWhereClause("fld = ?")
biz.setParams((fldval,))
gives an exception using PostgreSQL, the same with "%s"
gives an exception using SQLite.
Should I put a small example for both on codepad?
Greetings,
Sibylle
_______________________________________________
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]
