Zeoslib Portal

Hi Jan, What I meant was to introduce a variable that would hold the current TEXTSIZE value agreed with the MS SQL server for later use. For example in line 3785 ZDbcCache.pas: stBytes: if FColumnLengths[ColumnIndex] <= 0 or ... Here's a bit about it: https://database.guide/use-set-textsize-to-limit...

ZEOS 8.0.0 /trunk svn 7814) https://sourceforge.net/p/zeoslib/code-0/HEAD/tree/trunk Compiles and Works: - Lazarus 2.2.2(fpc 3.2.2)-Win32, - Delphi 2007(-ZBase64.pas), - Delphi 10.3.3 Rio-Win32/Win64/(Android/Android64- compiles but requires more thorough testing), - Delphi 11.1 Alexandria - Win32/...

It is a field name from the master table.
E.g.
ZQuery_master: tmaster - idm, valuem - select * from tmaster
ZQuery_detail: tdetail - idd, valued, idmd - select * from tdetail where idmd=:idm
ZQuery_detail.DataSource:=DataSource_master;

Michał

DataSource in ZQuery(detail) is used to link master-detail using SQL(in detail) "select * from tdetail where Field1_tdetail =:Field2_tmaster" And it generates the appropriate query every time the position of the master cursor changes. MasterSource works in conjunction with MasterFields and...

ZEOS 8.0.0 /trunk svn 7805(7807) https://sourceforge.net/p/zeoslib/code-0/HEAD/tree/trunk Compiles and Works: - Lazarus 2.0.0(-ZBase64.pas) - Raspberry Pi OS(Debian - ARM Linux 32b)- Firebird, MS SQL(FreeTDS), PostgreSQL, MySQL and SQLite, - Lazarus 2.2.0(fpc 3.2.2)-Win32, - Lazarus 2.2.2(fpc 3.2.2...

In my opinion, in the mssql-dblib connection it should be possible to read, set and use TEXTSIZE. For now, I uses in (Zeos8 trunk svn 7805)ZDbcCache.pas in line 3785: stBytes: if ((FColumnLengths[ColumnIndex] <= 0) or (FColumnLengths[ColumnIndex] = 2147483647) or (FColumnLengths[ColumnIndex] = 10737...

ZEOS 8.0.0 /trunk svn 7799 https://sourceforge.net/p/zeoslib/code-0/HEAD/tree/trunk Compiles and Works: - Lazarus 2.0.0(-ZBase64.pas) - Raspberry Pi OS(Debian - ARM Linux 32b)- Firebird, MS SQL(FreeTDS), PostgreSQL, MySQL and SQLite, - Lazarus 2.2.0(fpc 3.2.2)-Win32, - Lazarus 2.0.12(fpc 3.2.0)-Win...

Some components arrived. If you want to limit the size, exclude the databases you don't use: // Uncomment these defines to disable some DB drivers (reduce binary size) {.$DEFINE ZEOS_DISABLE_MYSQL} {.$DEFINE ZEOS_DISABLE_POSTGRESQL} {.$DEFINE ZEOS_DISABLE_DBLIB} {.$DEFINE ZEOS_DISABLE_ADO} {.$DEFINE...

ZEOS 8.0.0 /trunk svn 7793 https://sourceforge.net/p/zeoslib/code-0/HEAD/tree/trunk Compiles and Works: - Lazarus 2.2.0(fpc 3.2.2)-Win32, - Lazarus 2.0.12(fpc 3.2.0)-Win64, - Lazarus 2.2.0(fpc 3.2.2)-Win64, - Delphi 2007(-ZBase64.pas), - RAD Studio XE2-Win32/Win64/OSX32/C++32, - Delphi 10.3.3 Rio-W...

Hi hamacker, Write(in your article) that you are talking about ZEOS 7.2.14, not ZEOS 8, which has some improvements. These include additional components: ZTransaction, ZMemTable, server name unification, ODBC and OLEDB protocols, and an overall increase in convenience and performance. After all, whe...

ZEOS 8.0.0 /trunk svn 7772 https://sourceforge.net/p/zeoslib/code-0/HEAD/tree/trunk Compiles and Works: - Lazarus 2.2.0(fpc 3.2.2)-Win64, - Delphi 2007(-ZBase64.pas), - RAD Studio XE2-Win32/Win64/OSX32/C++32, - Delphi 10.3.3 Rio-Win32/Win64/(Android/Android64- compiles but requires more thorough te...

Hi Jan, Of course you can test on Linux, maybe right away in the 21c Express Edition. In fact, I hardly use Oracle, and my attention to the problem was that I came across it during testing. I dealt with it temporarily by using the table names explicitly. One more thing. Note that the server can be o...

Hi Jan, I see you are using Oracle 11g XE and maybe that's why you didn't respond to my remarks about ZEOS crashing when trying to open table lists in ZTable. The problem appeared with me when switching to 18g XE Maybe it is worth coming for something more modern, e.g. Oracle Database 18c or 21c Exp...

Hi Jan, All, But in Lazarus for odbc_w and SQLNCLI11 I also noticed a problem with the blob, this time elsewhere. More precisely here: Blob := FResultSet.GetBlob(ColumnIndex, TZLobStreamMode(Mode)); if (Blob <> nil) then Blob.Open(TZLobStreamMode(Mode)); if Blob <> nil then begin case Field.DataType...

Hi Jan, Summarizing My old FreeTDS and ODBC test are currently passing identically and correctly. It means: a 1 a a a b 1 b b b c 1 c c c A 1 A A A ====================== At present (svn7755), the problem actually remains the Lazarus BLOB behavior in combination with the ZMemTable. Michał