PG: circumvent an Infinity/NaN textwriter issue.
add TZCustomUniqueElementBinarySearchList with BinSearch-algo ascending find of elements
Merged revision(s) 7891, 7899, 7902-7938 from trunk:
8.0 resolve wrong IsNull state on binding arrays of !B!LOBa and a D7 issue un TZAbstractStreamedLob.SetBuffer()
8.0 PG: resolve a batch array dml issue binding arrays of BLOBs
8.0 FB3/BatchArrayDML: resolve an encoding issue on binding stUnicodeStream
8.0 use Length() if compiler support inlining
8.0 wrong ENDIF instead of IFEND commited. This broke old delphi compilation.
8.0 continue the TField.Required story, handle TZDataSet.ReadOnly correctly(if on open ReadOnly=False), move some hidden stack variables for error creation into seperate methods
8.0 rever old schramml patch on sqlite: we can't hide the original nullability state
8.0 get FPC 2.6.2 x86 running again
8.0 test the TField.Required prop on TZMemTable in all known scenarios
8.0 omit DSProps_CheckRequired again and introduce doCheckRequired as TDataSet.Option instead even if that Options are not realy portable/usefull for all descendants.
8.0 FPC/LCL add NO_TFIELDDEF_CREATEFIELD_SETFIXEDCHAR define
8.0 FPC hints
8.0 Oracle: fix an encoding issue on Batch bindings
Rollback r7891 and Merged revision(s) 7893-7898 from branches/8.0-patches:
8.0 second test-suite compile fix for FPC
8.0 fix last commit for FPC
8.0 add readback and compare values of InternalTestBatchArrayDMLBinding. New Fails will arrive!
8.0 add some more check overloads to the TestSuite
8.0 FB handle fixed-length attribute
8.0 add GetAsBytes to TZBytesField and TZBlobField
8.0 fix for last Commit. Test Test907497 did popup. Some FPC hints resolved
resolve some BatchArray MDL bugs
8.0 fix unexpected FPV FieldDefs-Collection behaior on Test_SF_Ticket512
8.0 SQLServer 2012+ igh_load.stBoolean should be nullable
8.0 possible Jenkins uses the sybase create skripts? Test_TField_DefaultExpression and TestArrayBindings do fail.
8.0 remove HAVE_UNKNOWN_CIRCULAR_REFERENCE_ISSUES on FPC. Add TField.DefaultExpression support. Determine TField.Required corectly
8.0 add RowAccessor.HasColumnDefaultExpression
8.0 rename InterbaseFirerbirdParam to InterbaseFirebirdParam
8.0 resolve TestInsertFailAndCorrectCachedUpdates for SQLite. Implicit test ConnProps_ForeignKeys option.
8.0 add Test_TField_DefaultExpression
8.0 SQLServer explicit null column stBoolean. MS implement SQL-standart vice verca for nullable columns on newer Servers. Thus TestArrayBindings fails on Jenkins
8.0 handle a FreeTDS/ADO Long Text/Binary detaction to create Lobstreams from a cahched ResultSet
9.0 Enable FB4 IBatch api and reenable lob binding code with additional check of current txn
8.0 add a IB/FB Txn monitoring test to verify Jan's findings. Test passes ):
fix ASA compilation on mORMot v1 if WITH_COLUMNS_TO_JSON is defined
Merged revision(s) 7887-7890, 7892 from trunk:
Zero-based FieldNo in TZQuery/TZReadOnlyQuery
Hi wp, should be resolved by r7887 on trunk(SVN). Please reopen if not OK. Regards, Michael
Firebird Smallint don't lookup on Smallint but Shortint does
Sorry for the very long delay! Resolved by r7899 on trunk(SVN). Please reopen if not ok. Regards, Mcihael p.s.: Please provide a compilable test case with full code next time. OTH it tooks to long to create a test-case.
8.0 Resolve Ticket512, assign the smallint buffer in GetFieldData
resolve Ticket 550
resolve emtpy row if insert did fail
add CreateFieldRequired Exception
32 Bit compilerhint
quickly resolve Ticket 539
Merged revision(s) 7882-7885 from trunk:
Interchange JSONWriter <-> ResultsWriter on ADO too
resolve ZTestCompInterbaseBugReport.TestDisconnect with legacy api
memoryleak resolved in case of connection loss
Interchange JSONWriter <-> ResultsWriter
accidently used patched branch
Firebird 3+ OO API - some corrections
Hi Joe, im starting from the premisse it's fine now? Closed...
TZParam: GetIsNullsAddr gets called with index values > High(Integer)
Resolved by R7879 plz reopen the ticked if not OK. The Cardinal vs. Integer swaps have been made to avoid bad index offsets for batch dml array bindings. Regards, Michael
Issue with Oracle DateTime out parameters.
Resolved by R7880 please reopen the ticked if not OK. Regards, Michael
resolve ZTestCompOracleBugReport.TestSF513 probably Ticket 513
fix unexpected RangeCheckErrors in ZDatasetParam.pas
IB/FB find NULL Flag for domain-fields too
compiler hint ..
fix wrong TZBindList.SetNull logic
circumvent bad code opt of FPC
fix generate PG batch stms
PG: remove an absolute symbol ColumnsToJSON using WITH_COLUMNS_TO_JSON(USE_SYNSOMMONS or MORMOT2) define
resolve a Delphi < XE10.4 Bug for the LOB fields GetAsVariant method
Firebird Smallint don't lookup on Smallint but Shortint does
I'm on it...
implizit convert date/time/datetime given as String into native values if TZParam.AsValue was used
fix TestAssignDBRTLParams for FPC
upgrade TestAssignDBRTLParams for boolean tests as noticed by Ralph
introduce EZDatabaseConnectionLostError because EZSQLConnectionLost are not related usually as mentioned by aehimself,
fix IB/FB create scripts of table high_load for varbinary fields
RowAccessor: don't test against the codepage for stUnicodeString
ADO fails with the OleVariant using VarArry and varBytes dimensions(1)
fix Android compilation
V8 OnValidate Issue
Next commit done: r7528 Is you issue resolved or isn't it? Btw. i've seen the comment about library loading @designtime. Louis you can use the TZConenction.LibraryLocation property for an absolute or relative path of the lib in designtime and runtime.
r7527: TZBooleanField returns 'True' all the time (PostgreSQL)
Thanks for the quick confirmation, Ralph. Closed.
Ralph, if you run into an issue, i made, others will run into same trap, propably. Yet i can't reproduce it. just commited a logic fix: r7529 Steps i've done: Add a TZTable to a Formular. Add a TZUpdateSQL to the formular and link it with tztable. Generate the SQL's. Run the appclication with and without persistent Parameters of the TZUpdateSQL component. Both do work. Wondering... What's the creation order of the two related components ? Which one is the first in the DFM/LFM file?
add missing owner of TZSQLString to FDeleteSQL, FInsertSQL, FModifySQL, FRefreshSQL
next approach to handle ticket #509 and #510 complete all fixed type OnValidate logic of the TZFields
Hello Luigi, yes i also realized the patch is incorect an hour after writing you. I commited a incomplete patch r7527 which should resolve your proplem. Can you confirm that? Regards, Michael
Hello Ralph, Can you please add more details or an example? My crystal ball is silent yet (no offence). It's related to TZUpdateSQL but more i can't figure out, sorry. What are you doing? Regards, Michael
next approach to handle ticket #509 (rollback last changes) Complete TZDate/TZTime/TZDateTimeField/TZBoolean/TZSmallInt field classes
Hello Luigi, thanks for the example. Patch done [r7526]https://sourceforge.net/p/zeoslib/code-0/7526/) So please update from trunk(SVN) and test. Please close if OK. Regards, Michael
Resolve ticket #509
change TestAssignDBRTLParams for old compiler
prepare MYSQL(no batch dml support) for emulated batch dml array bindings
fix old delphi compilation
Extend TestAssignDBRTLParams
FB/IB fix FmtBCD for precison = 1
ODBC fix varbinary() and raw-Clob bindings(from UnicodeString)
fix Currency value bindings from Variant
change the TZParam.AsValue code again. Commit r7507 (Pullrequest of aehimself) did disturb users code and produces loads of test-fails.