Zeoslib Portal

Hi Jan You're right about that "Prior". By the way, Cancel doesn't help in this case. However, the convention in Delphi has always been that Next would perform a Post if the record was in the edit state. Briefly speaking, sequence: Last; Edit; Next; Or: Insert; ... Next; It shouldn't cause...

Hi All, Now there is a new problem. When using ZQuery to modify a row of data, post and then edit, but without any modification, move to another row, move it back, and modify the data, an error will occur. I made a test project. It looks like a very serious error to me!!! "Previous" - does...

Hi Jan, You didn't quite understand me. The problem is that for FreeTDS, FColumnLengths[ColumnIndex] returns the current max limit for blob. ODBC initially makes -1 of this and therefore has no problem with detecting and copying blobs. After your recent changes(svn7752) to Delphi I still have to use...

Hey zhuyl,

If you refer to my example 22a.zip
This example was that somehow it works, not that it works perfectly.
That it is not read-only now.

I also observe problems with non-English characters, especially in Lazarus

Michał

Hi aehimself, All,

Merry Christmas to everyone!

1. It works for me (in conjunction with TZUpdateSQL).
I am enclosing an example: 2. What do you think about:
viewtopic.php?f=50&p=185826#p185826

Michał

Hi aehimself, Jan, All: I explained a bit with FreeTDS. I changed the line 3785 in zdbccache.pas from: stBytes: if FColumnLengths[ColumnIndex] <= 0 on: stBytes: if ((FColumnLengths[ColumnIndex] <= 0) or (FColumnLengths[ColumnIndex] = 2147483647) or (FColumnLengths[ColumnIndex] = 1073741823)) (From w...

Hi kjteng,

I'm not well versed but, have you paid attention to this design?:

https://github.com/utelle/SQLite3Multip ... s/releases
https://github.com/utelle/SQLite3MultipleCiphers
https://utelle.github.io/SQLite3MultipleCiphers/

Michał

Hi,

As if change detection for the memo field itself is missing.

Michał

ZEOS 8.0.0 /trunk svn 7740, 7741, 7742 https://sourceforge.net/p/zeoslib/code-0/HEAD/tree/trunk/ To be able to use ZMemTable SaveToStream and LoadFrom Stream, you should enable in the zeos.inc file: {$DEFINE ZMEMTABLE_ENABLE_STREAM_EXPORT_IMPORT} // line 97 Compiles and Works: - Lazarus 2.0.0(fpc 3...

Hi Jan, aehimself, However, it is still bad in all three case ( varchar(max), nvarchar(max), varbinary(max)-FreeTDS): a 1 b 1 ERROR2 c 1 ERROR2 ERROR3 Cannot access blob record in column 1 with type Bytes ============================== The aehimself fix does not help much: a 1 b 1 ERROR2 c 1 ERROR2 ...

Hi Jan,

You're probably right.
In every table with which I have a problem in testing (during ZMemTable tests) FreeTDS has a BLOB field.

Michał

Hi aehimself,

I coped, as you can see.
But many don't.

Michał

Hi Jan,

Continues remarks on svn 7733.
In svn 7733 Array BATCH-DML (e.g. for Firebird) stopped working, and it worked in svn7719.
Throws AV.
Test example in this thread:
viewtopic.php?f=50&t=146924

Michał

Hi Jan, Zeos8_svn_trunk_7733 Delphi 10.3.3-Win32 An entry in ZCore.dpk is missing: ZExceptions in '..\..\src\core\ZExceptions.pas', Compilation notes: [dcc32 Warning] ZDbcFirebirdInterbase.pas(4565): W1024 Combining signed and unsigned types - widened both operands [dcc32 Hint] ZDbcFirebirdInterbase...

As an aside, Zeos 7.2.14 patch has packages for Delphi 11.

Michał