mORMot and Open Source friends
All files named "SynDBODBC.pas"
Not logged in
Home Documentation Forum Download Blog Donate Timeline Tickets Wiki Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History for SynDBODBC.pas

2024-01-02
15:32
{6448} SQlite3 3.44.2 + happy new year 2024 file: [4ebfb36bf1] check-in: [b7c41d8371] user: ab branch: trunk, size: 97272
2023-01-01
17:02
{6427} happy new year 2023 ! :) file: [039b0a93b6] check-in: [4605481f3c] user: ab branch: trunk, size: 97282
2022-01-03
10:21
{6362} happy new mORMot year 2022! :) file: [e4429bec8e] check-in: [9f050e8fea] user: ab branch: trunk, size: 97282
2021-05-05
06:13
{6282} fixed Delphi compilation - broken by https://github.com/synopse/mORMot/pull/395 file: [7692b7f121] check-in: [095586c836] user: ab branch: trunk, size: 97274
2021-05-01
09:36
{6280} TODBCConnectionProperties.SQLStatementTimeoutSec + ODNB doubles binds - from https://github.com/synopse/mORMot/pull/395 file: [219f54d8b4] check-in: [f43a790969] user: ab branch: trunk, size: 97252
2021-01-02
14:17
{6200} Happy new Year 2021 to all! file: [697179f410] check-in: [f16571f373] user: ab branch: trunk, size: 96082
2020-10-12
14:18
{6145} SQL Server ODBC: set length for varchar parameters - from https://github.com/synopse/mORMot/pull/359 file: [f851a404e3] check-in: [13077356c8] user: ab branch: trunk, size: 96082
2020-09-02
08:03
{6126} small refactorings made during mORMot2 migration - no functional change file: [c8ede9bc1e] check-in: [c611334f21] user: ab branch: trunk, size: 95744
2020-06-26
11:13
{6077} refactored SynDB logging, and also SynDBOracle performance - from https://github.com/synopse/mORMot/pull/310 file: [ff83280426] check-in: [005bb47204] user: ab branch: trunk, size: 95698
2020-06-25
07:00
{6070} revert patch https://github.com/synopse/mORMot/pull/313 - problem fixed by msodbcsql17.5.2 file: [441b90332d] check-in: [b9cfbd807e] user: ab branch: trunk, size: 95628
2020-05-29
07:59
{6010} prevent "Invalid character value for cast specification" SQL Server error for small digits like 0.01, -0.0001 in ODBC SQL server 0.01 - thanks mpv for https://github.com/synopse/mORMot/pull/313 file: [b1bab58f51] check-in: [a922028e34] user: ab branch: trunk, size: 95874
2020-04-03
13:05
{5931} introducing TSQLDBLib.TryLoadLibrary file: [62c22cb896] check-in: [d7b652a473] user: ab branch: trunk, size: 95433
2020-03-22
14:03
{5877} new TSQLDBStatement.SQLLogBegin/SQLLogEnd methods to have as consistent Prepare/ExecutePrepared log information in all SynDB units file: [0a676fd436] check-in: [012ea78b2f] user: ab branch: trunk, size: 95537
11:06
{5875} reverted ISQLDBRows.RefCount check and introduced an explicit call to new ReleaseRows method file: [b8438c1fc5] check-in: [a1dfe9124e] user: ab branch: trunk, size: 95823
02:30
{5873} new TSQLDBStatement.ReleaseResources virtual method - called when ISQLDBStatement RefCount=1, i.e. when it is back to the cache file: [d50f101245] check-in: [e41e9c4085] user: ab branch: trunk, size: 95797
2020-03-21
23:27
{5871} small refactoring of the TSQLDBStatement*.Reset methods file: [e86029d708] check-in: [e3b7954cb2] user: ab branch: trunk, size: 95682
2020-03-20
19:20
{5849} all SynDB Prepare and ExecutePrepared methods would have the same log layout - thanks to new TSQLDBStatement.GetSQLLog method file: [3b8e94190d] check-in: [27cf0df9d1] user: ab branch: trunk, size: 95670
14:50
{5844} optimized TODBCStatement.ColumnsToJSON blob process file: [c172ae9434] check-in: [1dc9dd0abb] user: ab branch: trunk, size: 95776
2020-03-19
14:18
{5830} reviewed logging of SynDB units - including latest SynDBPostgres file: [79fce0270d] check-in: [8fe72b7036] user: ab branch: trunk, size: 95847
2020-03-17
09:02
{5822} avoid unexpected GPF when log is disabled file: [25d74bb0b6] check-in: [f3fb68c19a] user: ab branch: trunk, size: 95907
2020-03-06
11:02
{5772} introducing USERECORDWITHMETHODS conditional to use "record" instead of "object" and circumvent Delphi bugs in an unified way file: [4970c8b786] check-in: [969350c8fa] user: ab branch: trunk, size: 95829
2020-03-03
16:16
{5758} removed comments about changes/versioning which were old and redundant to our fossil/github source code management systems file: [c58d606de1] check-in: [a59d412f59] user: ab branch: trunk, size: 95810
2020-01-29
11:16
{5407} use [] instead of "" in exceptions to avoid JSON escape file: [456bb4cb0a] check-in: [932caf23d7] user: ab branch: trunk, size: 97638
2019-12-31
14:27
{5518} happy new mORMot's Year 2020 ! :) file: [231f3183e7] check-in: [69912b1fe1] user: ab branch: trunk, size: 97638
2019-10-30
15:10
{5436} restored Delphi compilation after https://github.com/synopse/mORMot/pull/249 merge file: [35eb2bb38f] check-in: [17f69d56e8] user: ab branch: trunk, size: 97638
2019-09-21
09:50
{5369} some minor comment fix after RTTI refactoring file: [e4d846da0c] check-in: [55eaa29f5d] user: ab branch: trunk, size: 97616
2018-12-31
16:50
{4933} happy new year 2019 ! :) file: [56056b9351] check-in: [d1590bef54] user: ab branch: trunk, size: 97628
2018-10-30
18:01
{4866} merge some mpv patches from github file: [56dd38be37] check-in: [691e78f9fa] user: ab branch: trunk, size: 97628
2018-08-01
20:41
{4705} moved some classes to SynTable to reduce the SynCommons size - also circumvent some Delphi IDE unexpected hangups file: [fe2d6b836a] check-in: [4990422963] user: ab branch: trunk, size: 97602
2018-03-28
14:57
{4485} optimized TODBCStatement.ExecutePrepared and ensure it compiles with Delphi 5 file: [4b62a537de] check-in: [45520af9cc] user: ab branch: trunk, size: 97589
2018-03-27
08:41
{4479} enhanced TODBCStatement.ExecutePrepared for array support file: [dc17457a8a] check-in: [6971ad1180] user: ab branch: trunk, size: 97605
07:37
{4477} try to circumvent Delphi error insight compiler limitations file: [23a0885eff] check-in: [6e24974510] user: ab branch: trunk, size: 91155
2018-02-03
15:13
{4220} circumvent Delphi 5 compiler bug file: [e0132c6955] check-in: [cf42214e16] user: ab branch: trunk, size: 91133
2018-02-02
21:30
{4216} enhanced logged information especially when no .map/.mab information is available or under FPC file: [71b7038129] check-in: [b396363e00] user: ab branch: trunk, size: 90997
2018-02-01
21:20
{4211} trim trailing line spaces in most source code files (no functional change) file: [aca7173054] check-in: [2ed9b8a89f] user: ab branch: trunk, size: 90973
2018-01-01
16:49
{4118} happy new year with mORMot ! :) file: [c68dca7f1e] check-in: [2b81f265c3] user: ab branch: trunk, size: 90984
2017-11-28
10:18
{4014} fixed "Timestamp" identifier casing file: [a8037a6843] check-in: [a5359a351e] user: ab branch: trunk, size: 90984
2017-01-30
10:31
{3364} introducing ISQLDBStatement.ForceDateWithMS property file: [bba86a5e6c] check-in: [65e28028a0] user: ab branch: trunk, size: 90984
2017-01-19
09:33
{3336} modified all links to https://synopse.info - since our web site is now HTTPS + HTTP/2 and rated A+ on https://www.ssllabs.com/ssltest/analyze.html?d=synopse.info file: [465bfdabdd] check-in: [b32f6a4110] user: ab branch: trunk, size: 90967
2017-01-15
14:32
{3319} added WithMS: boolean parameter for ISO-8601 time conversion to allow optional appending of .sss milliseconds - also implemented .sss parsing into ms value file: [ef630c5a79] check-in: [fc7fc84d70] user: ab branch: trunk, size: 90966
2017-01-01
15:05
{3305} we reached 2017 ! HAPPY MORMOT YEAR FOR EVERYONE! file: [94283a9642] check-in: [8f71b8aaf0] user: ab branch: trunk, size: 90688
2016-09-29
12:29
{3023} refactoring of "not" operator syntax to avoid unneeded parenthesis file: [141438c64d] check-in: [8fe39411b5] user: ab branch: trunk, size: 90688
2016-07-22
16:33
{2797} fixed SynDBODBC process of multiple clobs and blobs columns file: [9976504c7a] check-in: [17256866c6] user: ab branch: trunk, size: 90690
2016-06-09
15:22
{2726} basic Linux support for SynDBODBC file: [38996fb0e7] check-in: [a31e792fc3] user: ab branch: trunk, size: 90546
15:21
{2725} ensure ODBCInstalledDriversList() would use OpenKeyReadOnly instead of OpenKey - seems to work better e.g. in Windows 10 file: [4b8e4570ab] check-in: [e31f89e2f8] user: ab branch: trunk, size: 90437
2016-05-27
12:33
{2693} refactoring of Nullable*Null values - no functional change - also fixed associated documentation file: [64e44fb0db] check-in: [118ac5df33] user: ab branch: trunk, size: 90420
2016-01-27
13:15
{2311} we eventually reached end of 2015... time to run inc(Year) over all copyright notices! file: [5cf0d5c1e0] check-in: [fb42e47d72] user: ab branch: trunk, size: 90418
2016-01-26
13:23
{2306} got rid of unneeded WOW6432Node reference for ODBCInstalledDriversList() function file: [0ea05f6d82] check-in: [9d2aeee5b8] user: ab branch: trunk, size: 90418
10:45
{2303} SynDBODBC.pas improvements thanks to a new EMartin's patch
  • added GetProcedureNames for listing stored procedure names from current connection
  • addes GetViewNames and SQLGetViewNames for listing view names from current connection
  • added ODBCInstalledDriversList for listing installed ODBC drivers (not implemented for Linux)
  • overrided GetDatabaseNameSafe over ODBC connection string
 file: [118842cd98] check-in: [929025f385] user: ab branch: trunk, size: 90745
2015-12-05
15:37
{2126} ensure overriden TSQLDBStatement.ExecutePrepared methods would reset the associated connection's fLastAccessTicks, as used for [f024266c08] file: [52761adc92] check-in: [924faf462b] user: ab branch: trunk, size: 84311
2015-11-30
09:24
{2112} fixed Delphi 5 compilation issue of SynDBODBC.pas file: [3def8ebd83] check-in: [2ec5e07545] user: ab branch: trunk, size: 84245
2015-11-20
15:30
{2083} another fix for TODBCConnectionProperties.GetFields and GetProcedureParameters methods file: [d4ed8140e8] check-in: [5fdc9eae5c] user: ab branch: trunk, size: 84237
12:35
{2082} fixed TODBCConnectionProperties.GetProcedureParameters file: [c9dfb10390] check-in: [2a0a34c5bc] user: ab branch: trunk, size: 84098
2015-11-19
19:23
{2078} fixed stored procedure parameters support - see [2151abcdfc] file: [bf125a3849] check-in: [65396db07b] user: ab branch: trunk, size: 83992
17:02
{2076} Informix and stored procedure parameters support patch by Esteban Martin (EMartin) - thanks a lot for the very valuable input! file: [27c5196f31] check-in: [2151abcdfc] user: ab branch: trunk, size: 83599
2015-11-05
06:44
{2026} fixed ODBC BLOB parameter binding for some content file: [15cf7e8e1f] check-in: [86c59a0cb5] user: ab branch: trunk, size: 79436
2015-10-20
13:07
{2007} let SynDB statements fColumns[] internal array be sized with the exact known column count as proposed by mpv as [16e7e5c4b192] file: [e26843747e] check-in: [3749228e88] user: ab branch: trunk, size: 79445
2015-10-07
08:31
{1964} hidden the SQLDriverFullString from TODBCConnection published properties - this was awfully unsafe since the password was potentially logged and/or sent back to the REST client! file: [bc072c5c14] check-in: [b61c171ef6] user: ab branch: trunk, size: 79413
2015-08-15
11:35
{1791} fixed issue in TODBCStatement.ColumnBlob - thanks zed for the patch! file: [4bdbb224b2] check-in: [58f2ed96c3] user: ab branch: trunk, size: 79413
2015-07-14
09:52
{1635} fixed exception during Commit should leave transaction state - see [ca035b8f0da] file: [68203d148d] check-in: [8cdb6dc144] user: ab branch: trunk, size: 79538
2015-05-29
19:44
{1419} added AS400 iSeries Access ODBC Driver recognition file: [7ac6250e5e] check-in: [bb84e99138] user: ab branch: trunk, size: 79345
2015-05-15
10:57
{1355} comments and spaces clean-up of almost all source code files of the framework - no functional change, just code formatting uniformization file: [fffdc69802] check-in: [ab1fd53635] user: ab branch: trunk, size: 79330
2015-03-24
09:40
{1126} introducing new TSQLDBConnectionProperties.OnStatementInfo event, to be used e.g. to track ORA-28001 or ORA-28002 warnings about account expire file: [ecb91f77d8] check-in: [1f921ffa18] user: ab branch: trunk, size: 79346
2015-03-18
10:01
{1098} let SynDBODBC unit compiles with FPC file: [161b6a8851] check-in: [3da476a63e] user: ab branch: trunk, size: 78849
2015-03-03
22:29
{1028} introducing TSynConnectionDefinition class used e.g. for JSON-defined runtime instantiation of a TSQLDBConnectionProperties or TSQLRest instances via DefinitionTo*() and CreateFrom*() methods - see also function TSQLRestCreateFrom() which is able to create a TSQLRest with external tables file: [7dc842e15b] check-in: [78ce0600e1] user: ab branch: trunk, size: 78822
13:59
{1024} introducing TSQLDBConnectionProperties SaveTo/SaveToJSON/SaveToFile methods and TSQLDBConnectionPropertiesStorage.NewInstance*() methods to persist the database connection properties, and the associated class, as JSON file or variable - also included corresponding regression tests file: [8061db5a69] check-in: [ae854a5e71] user: ab branch: trunk, size: 78819
2015-02-19
20:17
{939} missing some files as reported by [834757fc77972593] file: [dda4bdf762] check-in: [e4c93de0ef] user: ab branch: trunk, size: 78745
2015-02-14
10:52
{899} remove some code which is not necessary any more with Delphi 5 since we now use RawUTF8 instead of PWinAnsiChar/PUTF8Char file: [05797b6d23] check-in: [c4ea5f0e13] user: ab branch: trunk, size: 78745
2015-01-14
15:45
{707} added some logic change in SynDBODBC to allow exact guess of the returned cursor column content file: [0a1efd9468] check-in: [84a2e60617] user: ab branch: trunk, size: 78789
15:24
{706} cosmetic fixes of comments in source - no logic change file: [83de4f8549] check-in: [1684159db7] user: ab branch: trunk, size: 78199
2015-01-02
12:08
{668} happy new year 2015! file: [ffbf41690b] check-in: [e08c81ec40] user: ab branch: trunk, size: 78142
2014-12-12
19:47
{640} ESQLDBException (and its descendants) will now append the current SQL statement to its error message, if TSQLDBConnectionProperties.LogSQLStatementOnException is defined, as requested by [ea07928ae9] file: [70a2c724ba] check-in: [9416d466bf] user: ab branch: trunk, size: 78142
2014-12-09
14:21
Limit size of SQl statement put into log to 2048 bytes file: [ee90cbcd16] check-in: [b72ec9e59f] user: pavel.mash branch: trunk, size: 77813
2014-11-23
16:55
{559} BREAKING CHANGE: new SynLog.pas and SynTests.pas units, extracted from SynCommons file: [501302c517] check-in: [881797779c] user: ab branch: trunk, size: 77827
2014-11-21
13:10
{552} added ForceBlobAsNull property to ISQLDBStatement (used e.g. by SynDBExplorer) file: [ec68d2ca66] check-in: [c13d3ce6f2] user: ab branch: trunk, size: 77816
2014-11-11
17:33
{493} added TSQLDBConnectionProperties.DBMSEngineName property file: [971cf13c56] check-in: [009c72ef5d] user: ab branch: trunk, size: 77867
2014-11-07
21:21
first commit from our internal Linux (Mint) VM - to make support of latest Lazarus 1.3 + FPC 2.7.1 from svn easier file: [c9963d7e43] check-in: [8f88c95618] user: ab branch: trunk, size: 77901
2014-11-03
12:19
{464} fixed typo about optional parameter DoNotFetchBlobs for TSQLDStatement.ColumnsToJSON() file: [a8bad78c2c] check-in: [1d14f45dad] user: ab branch: trunk, size: 77864
2014-08-26
15:00
added ESynException.CreateUTF8() constructor, more versatile than the default Exception.CreateFmt() version: this CreateUTF8() method is now used everywhere in the framework... in fact, we did a full review and refactoring of any exception raised in mORMot - big commit, indeed ;) file: [64143cd39c] check-in: [9b573b70f3] user: User branch: trunk, size: 77867
2014-08-20
08:22
ensure ExecutePrepared fails if BindArray() was used when the underlying provider does not support array binding file: [52506e24e8] check-in: [ad871ec39d] user: User branch: trunk, size: 77710
2014-07-09
06:47
fixed small typo in ODBC connection log file: [37b28610eb] check-in: [59ee0724bc] user: User branch: trunk, size: 77584
2014-05-16
19:39
fix some unexpected compilation errors (in Delphi 2007) file: [9e0949fef2] check-in: [0ebab4209b] user: User branch: trunk, size: 77585
2014-05-12
07:43
fixed typos and some compilation warnings file: [0cb4dc9842] check-in: [fd20a67fc6] user: User branch: trunk, size: 77563
2014-04-01
18:06
several code changes to follow up the prototype change of StrComp()-like functions from PUTF8Char into pointer parameters file: [402c7724c8] check-in: [bb92b8f376] user: User branch: trunk, size: 77558
2014-03-07
09:14
added MySQL benchmark and official support in documentation file: [33dbeccaa4] check-in: [3828725498] user: abouchez branch: trunk, size: 77558
2014-03-06
16:17
added official PostgreSQL support and benchmarks - blog article to follow soon - which is indeed an amazing engine, IMHO the best Enterprise-level Open Source database file: [11bfff3e9f] check-in: [8b69ea33ec] user: abouchez branch: trunk, size: 77264
2014-03-05
16:08
  • added IBM DB2 support to SynDB classes and mORMot ORM - tested with DB2 Express-C 10.5
  • now TODBCConnection.Connect() will recognize the DBMS from its driver name
 file: [348a2cf611] check-in: [103fcd7e36] user: abouchez branch: trunk, size: 76869
2014-03-04
12:50
added SQLite3 access via ODBC driver to the performance benchmark file: [81eb91e283] check-in: [0ad22954dc] user: abouchez branch: trunk, size: 74725
10:35
fixed issue in ODBC process when binding parameters: now specifies the correct SQL data type - drivers sounds pretty stable now, and MS SQL is able to run MultipleValuesInsert() custom SQL as expected (nice performance boost) file: [f0565f79dc] check-in: [0f77d8d6a5] user: abouchez branch: trunk, size: 74676
2014-03-03
21:12
fixed ODBC parameter binding file: [3784609aa3] check-in: [5fd8e8a8f1] user: User branch: trunk, size: 74203
17:18
introducing INSERT with multiple VALUES (..),(..),(..) for MS SQL Server 2008 - huge performance boost: now our direct OleDB client for MSSQL 2008 (displayed as "MSSQL local" in the documentation), outperforms FireDAC bulk insert mode :) file: [bd593d687b] check-in: [2c8f6061e1] user: abouchez branch: trunk, size: 73813
2014-01-10
12:15
reduced logging content when leaving some methods file: [b7b73f8df8] check-in: [c9930ca2ba] user: abouchez branch: trunk, size: 73665
2014-01-01
13:31
The little mORMot wishes you an happy new year 2014! file: [07bfe583bd] check-in: [44147954e2] user: User branch: trunk, size: 73647
2013-12-08
15:54
added TSQLDBConnectionProperties.StoreVoidStringAsNull, which will be set e.g. for MS SQL and Jet databases which do not allow by default to store '' values, but expect NULL instead file: [b4c03fe289] check-in: [549ab3276e] user: User branch: trunk, size: 73647
2013-11-13
16:40
enhanced PostgreSQL support for our SynDB units file: [8845c92865] check-in: [785d87bb8e] user: abouchez branch: trunk, size: 73595
2013-11-11
14:53
  • TODBCConnectionProperties.Create will now handle full ODBC connection string in aDatabaseName instead of ODBC Data Source name in aServerName
  • GetCol() will now retrieve all columns at once - mandatory for drivers not supporting SQL_GD_ANY_ORDER feature (like the "SQL Server Native Client 10.0" for ODBC)
 file: [fc414466bc] check-in: [17c4877408] user: abouchez branch: trunk, size: 73573
2013-10-26
15:07
ExecutePrepare method will log the SQL statement if sllSQL has been enabled in SynDBLog.Family.Level - feature request [59e349f58d] file: [492dcc1600] check-in: [4fdaf260a8] user: User branch: trunk, size: 70053
2013-07-09
08:30
added TSQLDBConnectionProperties.GetIndexesAndSetFieldsColumnIndexed() internal method, used by SynDBFireDAC and SynDBUniDAC overriden GetFields() implementations file: [e10c7e4bb2] check-in: [28e3adc78d] user: abouchez branch: trunk, size: 69919
2013-05-06
12:23
  • new TSQLDBConnectionProperties/TSQLDBConnection.OnProcess event handlers
  • TSQLDBConnection.Connect will now trigger OnProcess(speReconnected) and update the new TSQLDBConnection.TotalConnectionCount property
 file: [d7a6916f65] check-in: [4d80f1df05] user: abouchez branch: trunk, size: 69980
2013-05-03
09:05
  • TSQLDBConnection.Disconnect will now flush internal statement cache (this impacts all SynDB*.pas units)
  • TQuery.Execute() is now able to try to re-connect once in case of failure
 file: [24f829d821] check-in: [04fbed8876] user: abouchez branch: trunk, size: 69897
2013-04-16
15:18
added GarbageCollectorFreeAndNil() procedure to handle global variables proper finalization to nil - avoid error [8e3073c8c7] and [8546b4af1d] e.g. when used as design package in Delphi IDE (for all globals and class VMTs) file: [1d80b45008] check-in: [b79cd266e1] user: abouchez branch: trunk, size: 69830
2013-04-09
10:08
fixed ticket [d48283f5ec] about error at binding void string parameter file: [cf5d53bfb8] check-in: [85d7a6bf92] user: abouchez branch: trunk, size: 69852
2013-03-26
16:31
added DoNotFletchBlobs optional parameter to TSQLDBStatement.FetchAllAsJSON() FetchAllToJSON(), and ColumnsToJSON() methods (used e.g. by SynDBExplorer) file: [5997230d9b] check-in: [67eb6488e8] user: abouchez branch: trunk, size: 69614
2013-02-14
16:47
recognize now Interbase ODBC driver file: [b6e8e11512] check-in: [726485914e] user: abouchez branch: trunk, size: 69466
2013-01-30
13:32
  • added RaiseExceptionOnError: boolean=false optional parameter to TSQLDBConnection.NewStatementPrepared() method, and TSQLDBConnection.LastErrorMessage and LastErrorException properties, to retrieve the error when NewStatementPrepared() returned nil
  • TSQLDBConnectionProperties.Execute/ExecuteNoResult methods will now use prepared statements cache (if any)
 file: [f42317723b] check-in: [5f4d9a1c8b] user: abouchez branch: trunk, size: 69444
2013-01-23
20:22
SynDBFirebird is now able to connect to a Firebird DB, and let Firebird Embedded library create a new database file if it does not exist yet file: [e9d1e2137e] check-in: [676df50744] user: abouchez branch: trunk, size: 69371
2013-01-22
20:45
Huge performance enhancement of SynDB* units (OleDB not yet implemented)
  • SQL statements are now cached by default - in some cases, it will increase individual reading or writing speed up to a factor of 4x
  • introducing new ISQLDBStatement interface, used by SQL statement cache
  • implements Oracle server-side statement caching for a major performance improvement e.g. for one row queries
 file: [1427bc9ecf] check-in: [0827a73762] user: abouchez branch: trunk, size: 69402
09:38
SynDB* units now trim any spaces when retrieving database schema text values file: [fc0fdeb7f3] check-in: [49e52de0c5] user: abouchez branch: trunk, size: 68797
2013-01-09
16:32
enhanced FireBird compatibility file: [a2b41981ed] check-in: [43d286622e] user: abouchez branch: trunk, size: 68668
08:18
added FireBird ODBC driver detection file: [58107b4ca6] check-in: [8116d0e36e] user: abouchez branch: trunk, size: 68931
2012-12-31
14:34
preparing new Year's eve ;) file: [caeb20e9a2] check-in: [8e74517c2d] user: ab branch: trunk, size: 68802
2012-12-11
11:20
fixed unexpected exception raised if SQL_NO_DATA is returned file: [84e6d1c620] check-in: [bdf361b8e8] user: abouchez branch: trunk, size: 68802
2012-11-12
13:55
fixed ticket [4c68975022] about broken SQL statement when logging active file: [c7cedb4528] check-in: [9b38419bb7] user: abouchez branch: trunk, size: 68635
2012-09-13
17:12
- circumvent restriction of some non-Unicode ODBC drivers to use SQL_C_CHAR parameter binding instead of SQL_C_WCHAR (e.g. Microsoft Oracle ODBC) - circumvent restring of some drivers which expect SQLExpect() columns to be retrieved in left-to-right order
 file: [0c1c850357] check-in: [af6f3e43e6] user: abouchez branch: trunk, size: 68523
2012-08-29
15:50
fixed several LVCL and Delphi 5 compilation issues file: [54ac8ce717] check-in: [9422fb8309] user: ab branch: trunk, size: 66719
2012-08-21
14:41
  • added TSQLDBConnectionProperties.DBMS property, and huge code refactoring among all SynDB* units for generic handling of DBMS-specific properties
  • added TSQLDBConnectionProperties.AdaptSQLLimitForEngineList for handling the LIMIT # statement in a database-agnostic form + includes full coverage of unit testing
 file: [64a48c2da8] check-in: [403804e7d0] user: ab branch: trunk, size: 66420
2012-08-15
14:38
  • SynDB shared database specific SQL magic enhanced
  • documentation update
 file: [a9ca98d69b] check-in: [9755c6341b] user: ab branch: trunk, size: 67316
08:42
improve documentation of Step() methods to avoid confusion - see http://synopse.info/forum/viewtopic.php?pid=4839#p4839 file: [77abfb2de5] check-in: [05c5fe1469] user: ab branch: trunk, size: 66809
2012-08-14
11:20
fixed ticket [4f5df7f18f] - about potential overflow of TSQLRestServerStats values (changed to QWord kind of property) file: [29cf3b6831] check-in: [50f9b92f9d] user: ab branch: trunk, size: 66497
2012-08-10
16:45
fixed Unicode compilation issue file: [d4d6282731] check-in: [c6ac8e314f] user: ab branch: trunk, size: 66491
14:36
added ODBC support to SynDBExplorer (sounds to work fine, so far - but sower than direct OCI access) file: [168cc5d863] check-in: [f324d469ee] user: ab branch: trunk, size: 66419
09:59
void TEXT column export fix file: [8dcb5722aa] check-in: [8044c5ea7c] user: ab branch: trunk, size: 63007
09:04
  • introducing SynDBODBC working code, tested with ODBC Oracle provider :)
  • code refactoring of SynDB units, especially about error handling and ODBC integration
 file: [d8a979cf12] check-in: [3efaf59e06] user: ab branch: trunk, size: 62937
2012-06-26
16:33
now TSQLDBStatement.ColumnToVarData method will store '' when value is 0, or a pure date or a pure time if the value is defined as such, just as expected by http://www.sqlite.org/lang_datefunc.html - i.e. SQLite3DB file: [cdb470b5ef] check-in: [8cbba5961d] user: G018869 branch: trunk, size: 37748
2012-01-24
14:26
  • fixed rounding issue in ExtendedToString() and all corresponding wrappers like DoubleToStr*, Add(aDouble)..
  • get rid of wrong "Decimal" parameter in float to text conversion
 file: [5f83e40029] check-in: [bf0a9eab82] user: G018869 branch: trunk, size: 37744
2012-01-20
13:33
changed copyright notice to "(C) 2012" - yes, happy new year ! file: [42f4453ac9] check-in: [d8b446f0b5] user: G018869 branch: trunk, size: 37726
2011-10-06
16:35
Added: introducing SynDBODBC.pas, unit for ODBC 3.5 library direct access classes (to be used with our SynDB architecture) - initial commit, with no implementation file: [b5e73154d7] check-in: [fed5c7b31b] user: G018869 branch: trunk, size: 37726
©2010-2022 Synopse Informatique