Activity for Fr0sT.Brutal
-
Fr0sT.Brutal posted a comment on ticket #555
Seems your version doesn't have the required unit. It was added in 12.10.2019. Why not update your FPC? In general, not much efforts are given to support of old FPC versions unlike for Delphi because FPC is free and nothing prevents from upgrading
-
You're using unofficial repository that is way beyond the current state. The proper one is https://github.com/marsupilami79/zeoslib As far as I can see, the issue is fixed in current upstream
-
You're using unofficial repository that is way beyond the current state. The proper one is https://github.com/marsupilami79/zeoslib
-
Well, these records are internals, FPC team has the full right to change them without notice and backward compat. Relying on internals has always been unstable
-
Seems like bug indeed but why you need to ping? Just execute query and check results/exceptions
-
IMHO previous behavior was much more logical and safe. New SQL is equivalent to full re-init of query. Current behavior could lead to unpredictable results, f.ex., re-using temp queries for short actions. tmpQ.SQL.Text := 'select username from users where userid = :ID'; tmpQ.ParamByName('ID').Value := 123; tmpQ.Exec; ... tmpQ.SQL.Text := 'delete from very_important_data where (dataID is NULL and :ID is NULL or dataID = :ID'); // intend to do some cleanup from junk records, assuming 'ID' is NULL by...
-
IMHO previous behavior was much more logical and safe. New SQL is equivalent to full re-init of query. Current behavior could lead to unpredictable results, f.ex., re-using temp queries for short actions. tmpQ.SQL.Text := 'select username from users where userid = :ID'; tmpQ.ParamByName('ID').Value := 123; tmpQ.Exec; ... tmpQ.SQL.Text := 'delete from very_important_data where (dataID is NULL and :ID is NULL or dataID = :ID'); // intend to do some cleanup from junk records... tmpQ.Exec; // but OOPS,...
-
Well, there is -scc for that case. Anyway it's up to you, I'm glad to make this wonderful app better.
-
That output can be redirected to file. I tested redirection with cmd & > and it worked
-
Windows console version disrespects current code page (with fix)
-
I solved this by disabling manifest creation in project options following advice from SO Then I had to comment out usage of My_SetDefaultDllDirectories as it caused linker to fail with "external not found". I've no idea why considering that build via command line executed fine.
-
In my other projects I previously used raising procs like Error(msg) but then changed my mind as compiler hints were disturbing too much. Anyway when you see raise keyword in the code you have a better understanding of what's going on there. So I redesigned my procs to funcs that create and return exception and use them like raise Error(msg). This is just insignificantly longer but much more obvious. IOW, for me changing RaiseUnsupportedException to raise CreateUnsupportedException only brings advantages....
-
In my other projects I previously used raising procs like Error(msg) but then changed my mind as compiler hints were disturbing too much. Anyway when you see raise keyword in the code you have a better understanding of what's going on there. So I redesigned my procs to funcs that create and return exception and use them like raise Error(msg). This is just insignificantly longer but much more obvious. IOW, for me changing RaiseUnsupportedException to raise CreateUnsupportedException only brings advantages....
-
In my other projects I previously used raising procs like Error(msg) but then changed my mind as compiler hints were disturbing too much. Anyway when you see raise keyword in the code you have a better understanding of what's going on there. So I redesigned my procs to funcs that create and return exception and use them like raise Error(msg). This is just insignificantly longer but much more obvious. IOW, for me changing RaiseUnsupportedException to raise CreateUnsupportedException only brings advantages....
-
Yes, that change was pretty massive so it was done in active branch only. But you can use it for reference anyway. And yes, driver-specific options are mostly not listed there as it's better to study them in driver's official docs. Parameter names were changed according to API: https://dev.mysql.com/doc/refman/8.0/en/mysql-options.html
-
Yes, that change was pretty massive so it was done in active branch only. But you can use it for reference anyway. And yes, driver-specific options are mostly not listed there as it's better to study them in driver's official docs.
-
If you want to study all supported connection parameters, look at src\core\ZConnProperties.pas and src\dbc\ZDbcProperties.pas
-
PG: TZPostgreSQLConnection.AbortOperation beautified
-
PG: TZPostgreSQLConnection.AbortOperation beautified
-
Btw, we have dataset's KeyFields property so in most cases RefreshCurrentRowSQL could be auto-generated
-
Agree with RefreshRowSQL, auto-detecting a unique key would require full-featured Skynet AI :))
-
TZInterbase6Connection.PingServer, use constants instead of magic numbers
-
- Cosmetic changes for Interbase. Fixed usage of isc_dpb_connect_timeout in GenerateDPB (it is int parameter)
-
Fixed changing TZAbstractConnection.ReadOnly wasn't changing underlaying FConnection.ReadOnly
-
TZInterbase6Connection.StartTransaction, fix necessity of specifying 'isc_tpb_version3' in Parameters if TransactIsolationLevel = tiNone and Parameters contain any of the 'isc_tpb_*' item
-
Redesign in ZDbcInterbase6ResultSet unit.
-
Fix typo in the name of constant
-
When returning Boolean fields as strings, true/false values are used instead of non-standard yes/no
-
Added property "Liblocation" to test config, now the client lib path could be set in test.properties file
-
FB: host version and capability determining are encapsulated inside IZInterbaseDatabaseInfo instead of scattering among DBInfo, Metadata, Connection and Sequence. Added methods SupportsNextValueFor, SupportsTrim, SupportsBinaryInSQL, GetMaxSQLDASize that follow general IZDatabaseInfo.Supports*/Get* approach.
-
* Refactoring of TZURL.SetURL, code shortened and simplified + make possible specifying full paths with ":" in parameters (SF #158). Some tests added
-
Fix some warnings under Unicode Delphi
-
Fix bug introduced in r4028 (wrong URL construction)
-
IB/FB: GetAffectedRows, redesigned to process the buffer correctly; returns results for stExecProc StatementType. Internal routines use new ReadInterbase6Number.
-
Magic constants 0 and 1 replaced by InvalidDbcIndex and FirstDbcIndex where appropriate. This fixes wrong behavior in GENERIC_INDEX mode)
-
IB/FB: GetExecuteBlockString, fix Returning couldn't be determined
-
Removed thread-unsafe manipulations with global FormatSettings. Added SQLStrToFloat function and internal FSSqlFloat: TFormatSettings variable.
-
Fix TZAbstractConnection.GetEscapeString was not returning a result
-
FB/IB: Fixed half-missing implementation of Boolean fields
-
! Fixed not raising exceptions in TZNumericField.ConvertSigned, ConvertUnSigned, ConvertExtended, removed compiler satisfactions (now with exception raising they're useless)
-
"{$IFDEF GENERIC_INDEX}0{$ELSE}1{$ENDIF}" clauses replaced by generic FirstDbcIndex, "{$IFDEF GENERIC_INDEX}-1{$ELSE}0{$ENDIF}" replaced by generic InvalidDbcIndex.
-
Internal code simplification commit, no real change.
-
Internal code simplification commit, no real change.
-
ZSysUtils.GUIDToBuffer, type of Source changed to Pointer to indicate it's a binary data and avoid excess typecasts. Added some internal typecasts to allow pointer maths under old Delphis. Removed several unnecessary if's increasing performance by 8%
-
FB/IB: sequence name is quoted with IdentifierConvertor
-
FB: added missing GUID type handling for parameters
-
Minor cosmetic code changes
-
ZDbcCache.pas: TZRowAccessor, internal optimization pt.2.
-
Internal change - finished work on unifying column index definition for metadata methods.
-
ZDbcCache.pas: TZRowAccessor, internal optimization.
-
ZDbcMetadata.pas:
-
ZSelectSchema.pas:
-
ZSelectSchema.pas: fixed compilation fail introduced in 4128. TZSelectSchema.LinkFieldByIndexAndShortName uses common conversion of ColumnIndex without additional units. This required removing const modifier but it was useless anyway.
-
Cleanup of TZ*Metadata.DecomposeObjectString - removed overrides that were exact copies of parent method (ADO, SQLite), made use of parent methods instead of copying code (DbLib). TZAbstractDatabaseMetadata's method slightly optimized for case of empty parameter and a description added
-
MySQL: fixed metadata not respecting connection properties (SF #233)
-
Warnings cleanup
-
TZAbstractRODataset: property SQL is placed after ParamChar and ParamCheck (SF #164).
-
ZURL internal optimizations & code simplifications, added two tests
-
Force disable Range check for all Zeos units under D7 to avoid internal error C1118
-
Added RemoveChar, AppendSepString, BreakString functions with test cases
-
ZURL internal cleanup/optimizations using new functions
-
Internal cleanup/optimizations using new functions
-
Assignments of one TStrings.Text to another replaced with Clear+AddStrings which is not only much faster (avoiding string join and split) but also keeps multiline values - f.ex., FB3's isc_dpb_config parameter
-
FB3+: WireCompression option won't overwrite other isc_dpb_config values
-
Internal: DefineFields and DefineSortedFields routines simplified and commented; also they raise exception for fields defined with a number greater than total field count of dataset (previous version was ignoring this entry); DefineSortedFields now correctly processes the case of a field named Asc or Desc
-
Internal code simplification/refactoring.
-
Internal code simplification with AppendSepString routine
-
Internal optimizations/code simplifications
-
FB/IB: fields of types blr_varying(2) (VARCHAR) and blr_cstring(2) (CSTRING) with codepage CS_BINARY (OCTETS) are considered TBytes.
-
FB/IB: pt.2 of "fields of types blr_varying(2) (VARCHAR) and blr_cstring(2) (CSTRING) with codepage CS_BINARY (OCTETS) are considered TBytes." - metadata part. UncachedGetProcedureColumns queries RDB$CHARACTER_SET_ID field. Also UncachedGetProcedureColumns and UncachedGetColumns do assign Remarks field of columns.
-
Internal: use BufferToBytes (code shortening), more Move() optimizations
-
FB/IB: internal TZInterbase6Connection changes
-
Internal: Move() optimizations, use ZFastCode.Move() if defined
-
FB/IB: returned some code that was lost during merge
-
Internal: StrToBytes, removed empty string checks (Move() does them itself)
-
(Internal) ZDbcAdoStatement.pas: temp variable in TZAdoCallableStatement.ExecuteQueryPrepared shortening the code
-
aww forgot to use unit
-
ZURL - property Text is used as simple TStringList's one. Escaped value is got/set by URLText property. Escaping includes both replacing CRLF's to ';'s and ';'s to TABs. This allows specifying properties with ';'s inside. Added one test demonstrating the fixed behavior (fails with previous code).
-
Remove unneeded units
-
FB: two minor bugs
-
Fix exception's message
-
IB/FB: fixed index manipulations in event alerter introduced in prev commit
-
IB/FB: fixed incorrect event registration in event alerter that affected only Unicode Delphis
-
Merged revision(s) 4431-4433 from trunk:
-
Merged revision(s) 4014-4030 from branches/testing-7.2:
-
+ IZResultSetMetaData.FindColumn method added (preparation for INSERT-RETURNING feature). IZResultSet.FindColumn just calls the metadata's method.
-
+ Support of INSERT...RETURNING construction. New Dataset option "InsertReturningFields" that has to have value of "," or ";"-separated list of fields that will get their values after Post (f.ex. "ID, Master_ID; Something"). The field list will be added to INSERT statement separated by "," (InsStatement = 'INSERT INTO ... RETURNING ' + FieldsList). This ability is supported by Firebird, Postgre and Oracle but only Firebird implementation is done.
-
Merged revision(s) 4034-4036 from branches/testing-7.2:
-
ZDatasetUtils.pas: added ExtractFields routine
-
+ Exceptions now have SpecificData: TZExceptionSpecificData property that might be filled by engine implementations with any engine-specific data. Implemented for Firebird.
-
Make TZGenericCachedResolver.DefineWhereKeyColumns respect "KeyFields" parameter (used for UPDATE, DELETE). Thus WhereKeyOnly option could be used with those datasets for which primary keys couldn't be determined via metadata (VIEWs).
-
Fixed warnings and string conversion issues for Unicode Delphis
-
ExtractFields moved from component/ZDatasetUtils.pas to dbc/ZDbcUtils.pas to keep isolation of logical levels and fix non-buildable packages
-
Fix memory leak in ExtractFields
-
* All literals of dataset and connection properties are replaced by constants. Two units added - core/ZConnProperties (most common connection props) and dbc/ZDbcProperties (dataset and driver-specific properties). Most of properties are accompanied with comments.
-
Added new files that were missing in r4044
-
Fixed warnings and improper use of ZFastCode unit introduced in r4044
-
Merged revision(s) 4063-4064 from trunk:
-
Merged revision(s) 4061 from trunk:
-
FB/IB: Significantly simplified and optimized TZInterbase6DatabaseMetadata.UncachedGetProcedureColumns/UncachedGetColumns with the price of dropping support of IB5. UncachedGetCollationAndCharSet uses indexes instead of FindColumn as well because both used queries return the same column set.
1 >