Zeoslib Portal

Hello jan,
{$DEFINE ZEOS_DISABLE_INTERBASE} and {$DEFINE ZEOS_DISABLE_FIREBIRD} Will cause compilation errors。Error unit：ZPlainFirebird 。
compiler: lazarus 2.2.2 and zeos8.0

zeos.inc file // 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_DISABLE_INTERBASE} {$DEFINE ZEOS_DISABLE_FIREBIRD} {.$DEFINE ZEOS_DISABLE_SQL...

Thank you, Jan
With your reminder, the problem was solved. Because mssql does not have a patch installed, tcp/ip cannot be used.

testing environment：zeoslib-code-0-r7936-trunk，lazarus, freeTDS1.3

hello marsupilami,
thanks

hello marsupilami,

We use zquery as a memory table, so CachedUpdates is used. My suggestion: When the current record is in the editing state, move the record back and forth to post automatically instead of cancel.

hello, 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. ZDetectUTF8Encoding, there is one place that has not been changed, and t...

hello marsupilami,

3. When the data has non-English characters (such as Chinese), it will be wrong to save to the temporary table.

Sorry, item 3 is not a problem, but I did not specify the client code page. Thank you for helping me solve the problem.

Merry Christmas to everyone! test has the following problems: 1. There is a problem with the SQL statement without a table, such as ‘select getdate()’. Debugging to unit ZSybaseAnalyser.pas: TZSybaseStatementAnalyser.DefineSelectSchemaFromQuery error. 2. Using temporary tables under SQL 2000 will ca...

Thanks

Hello
Can the problem be solved?

The ZDetectUTF8Encoding of the ZEncoding unit has a bug. SizeOf(PCardinal) should be changed to SizeOf(Cardinal) function ZDetectUTF8Encoding(Source: PAnsiChar; Len: NativeUInt): TEncodeType; var c: Byte; EndPtr: PAnsichar; begin Result := etUSASCII; if (Source = nil) or (Len = 0) then Exit; EndPtr ...

hello
I forgot to upload, I am uploading now.

hello
I made a test example, you can test it, the database is ms sql server.

The database I use is MS SQL Server, and the temporary table created is in the database tempdb, from which the metadata of the table can be obtained.