- I added a property to the Ancestor of tzConnection: AutoRefreshTableAfterSQLExec which can only be true if AutoCommit is true, but when it is, it parses out the SQL that was just executed and if it was an UPDATE or DELETE, it automatically refreshes all the tables used in that SQLExec.
I added a ConvertBooleansFieldsToIntegerComparisons that defaults to true for SQLite3 but can be set to true for other DBs and which can automatically parse both SQL and filters to convert "bare" boolean fields (such as HasFlag) into numeric comparisons. Thus "SELECT * FROM MyTable WHERE HasFlag" would internally become ""SELECT * FROM MyTable WHERE (HasFlag=1)"
Want to Offer Some Code Extensions; where should I post them
Moderators: gto, EgonHugeist, olehs
-
- Fresh Boarder
- Posts: 24
- Joined: 21.09.2012, 10:13
Want to Offer Some Code Extensions; where should I post them
I am just getting started with ZeosLib and SQLite3 and I ran into some situations--like the lack of boolean support in SQLite3--that required some patching on my part that I think might be useful to other people.
- EgonHugeist
- Zeos Project Manager
- Posts: 1936
- Joined: 31.03.2011, 22:38
BytePlayer,
maka a *.patch or *.diff file with you changes and attach it here.
Hint: We solve all DBRM special options with the TZConnection/TZDataSet.Properties. Only common properties are available in the property editors.
Thanks for you constribution.
maka a *.patch or *.diff file with you changes and attach it here.
Hint: We solve all DBRM special options with the TZConnection/TZDataSet.Properties. Only common properties are available in the property editors.
Thanks for you constribution.
Best regards, Michael
You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/
You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/