Zeoslib Portal

Hi Jan, aehimself, All,

A better example varchar(10), varchar(max), nvarchar(max), varbinary(max)
odbc_w:
a 1
b 1
c 1
A 1

mssql-FreeTDS:
a 1
-Out of memory
-Out of memory
-Cannot access blob record in column 1 with type Bytes

Delphi 10.3.3-Win32 Zeos8svn7719 Michał

Hi,

Sample application running for odbc_w:
1
1

and a causing error for FreeTDS:
1
Out of memory

Delphi 10.3.3-Win32 Zeos8svn7719
Michał

Hi, Also now, unfortunately, I don't have much time. In general, I am concerned that the following data types(with data) may be buggy loaded into ZQuery / ZTable using mssql-FreeTDS: NTEXT, TEXT and IMAGE NVARCHAR(max), VARCHAR(max), and VARBINARY(max) And this is sometimes revealed only when trying...

Hi aehimself, Jan, All: After more thorough testing, for mssql FreeTDS: MS SQL type image is loaded incorrectly into ZTable / ZQuery and cloned to ZMemTable. MS SQL type nvarchar(max) is defectively copied / cloned to ZMemTable from ZTable, ZQuery. In the case of odbc_w, everything is fine (includin...

Hi aehimself, Jan, It seems to me the problem is earlier. When opening a table from MS SQL via FreeTDS. The file generated by the ODBC connection is loaded and written to the ZMemTable without any problems. I noticed that an error 'Cannot access blob record in column n with type Bytes' occurs for a ...

Hi kjteng,

Thanks.
I see that you solved the problem of copying some fields and data.
If in the future you have something interesting with ZMemTable, publish it.

Michał

Hi, odbc-w-SQL Server Native Client 11.0 ZQuery: After Open: pub_id;WideString(24);4;-1; logo;Blob(15);0;0; pr_info;WideMemo(39);0;0; ZMemTable: After Clone: pub_id;WideString(24);4;-1; logo;Blob(15);0;0; pr_info;WideMemo(39);0;0; After Save/Load: pub_id;WideString(24);4;-1; logo;Blob(15);0;0; pr_in...

Hi All, I have noticed one problem with the ZMemTable Applies to MS SQL and FreeTDS (in any version up to 1.3). Loads MS SQL via FreeTDS and clones tables with a blob field to the ZMemTable. When trying to SaveTo File (SaveToStream), this ZMemTable always throws an error. There is no problem when co...

Hi kjteng,

I was hoping that since you use this, you would write some useful procedures and share with us.

Michał

kjteng wrote: ↑17.11.2021, 11:56 Where can I find ZMemTableUtils.pas ?

I thought you would write.

Michał

Hi kjteng,

Note that you can copy the structure without some fields.
As well as adding new fields.
And copy the data in a traditional way, indicating the correct ones.
In fact, a library of such routines, the ZMemTableUtils, would come in handy.

Michał

Hi aehimself, All,

It is a pity that there is no compatibility of the SaveToFile / LoadFromFile format of streams between systems and compilers.
Therefore, they are not transferable and shared.

Michał

ZEOS 8.0.0 /trunk svn 7717,7719 https://sourceforge.net/p/zeoslib/code-0/HEAD/tree/trunk/ NEW: SaveToStream and LoadFromStream for ZMemTable(It's easy to use SaveToFile/LoadFromFile). Compiles and Works: - Lazarus 2.0.0(fpc 3.3.1)?(-ZBase64.pas) - Raspberry Pi OS(Debian - ARM Linux 32b)- Firebird, ...

Hi Doug,

Show what you have for ZConnection in .dfm and what MySQL and client version you are using

Michał

Hi Doug,

What does it say here?:
viewtopic.php?f=3&t=44184

Michał