Zeoslib Portal

@jan
thanks for your suggestions. Lazarus 2.2.2 came with FPC 3.2.2. ill try that 7.2 patch from svn, as 8.0 is still "beta"
hoedlmoser

@Michal
thanks for your reply. i replaced the 7.2.14 with 8.0 from svn trunc 7930 and it works (still using Lazarus 2.2.2 64 bit and sqlite.dll 3.8.7.0)
regards
hoedlmoser

Hello, i came over a problem with version 7.2.14 on a lazarus 2.2.2, messing up with german umlauts when inserting a SQLite table. There is a small test project attached, with the sqlite.dll in use, just for compiling and running (there will load several sql-inserts into the synedit, to be marked an...

hi, 1. Exact Version and ProductName of the Server MS SQL 2000 Standard 32 bit with sp4 running on a 64 bit server 2. Exact Version and ProductName of the Compiler I dont know how to get an "exacter" version of the compiler than the one i mentioned above 3. Exact Version and ProductName of...

hi again,

TField.DataType returns "ftVarBytes". This is on a 32 bit Lazarus 1.8.2

kind regards
hoedlmoser

Hi Michael,

its a fixed size binary, like described in the example

kind regards
hoedlmoser

Hi, The GetData() method in version 7.3 (r6881) now returns binary values shifted 2 bytes, eg. for binary(16) = 0x000000FF0000000000000000000000FF GetData() returns 0x1000000000FF00000000000000000000 Seems that the first 2 bytes contain the length of the binary instead of data. kind regards hoedlmoser

Hi Jan,

sorry for the delay, i didnt expect any more posts on this thread. Of course i would test this 7.3 version if i only could find it.

best regards

hoedlmoser

Hi Michael,
thanks for the advice

kind regards
hoedlmoser

thanks for your detailed answer. I changed the binary field definition to NOT NULL defaulting to 0x0, as workaround for that update issue. To migrate all our stuff from 2K to 2017 would be a lifetime job for a one man show, so we can forget about it. ...any of the following DDL statements have ever ...

Hello marsupilami, Thanks for your answer. We are running an old 2K and a 2017. If switching to 7.2 solves the binary problem, i will try it. As far as i remember, the metadata query has to be changed in this version with the old one. This works on 2K and 2017 as well. I dont know what Fr0sT means b...

Hello, I am using zeoslib 7.1.4-stable, protocol = "FreeTDS_MsSQL-2000" + "msdblibr.dll" and got some trouble with binary fields. If the binary/varbinary value is null, it will not be updated. The varbinary value will be truncated to the size it had before the update. The table d...

Hi Guys, there is a problem with the "ZDbcDbLibMetadata.TZMsSqlDatabaseMetadata.UncachedGetColumns" function. This generates a SQL statement like this, eg. for table 'theTablename' (added comments): select c.colid, c.name, c.type, c.prec, c.scale, c.colstat, c.status, c.iscomputed from sys...

Dear Zeos developers, in version 7.14 stable I came up with a problem in unit ZDbcDbLibMetadata.pas (Lazarus, MSSQL): The function "TZMsSqlDatabaseMetadata.UncachedGetColumns" performs two (redundant?) queries for metadata. In first place 'sp_columns' procedure is called, later syscolumns ...