Zeoslib Portal

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.

• 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)"

Where should I post these proposed additions?

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.