Zeoslib Portal

I want to compare only Date and only Time.
The patch is attached.

Greetings, Bernhard

Hello,

now I must disable required check on one table (TZTable).
The required fields on a MariaDB server are filled, but the check raises an exception.

Greeings, Bernhard

Hello,

I think this is the best solution:

TMySQLLengthArray = array[0..999] of Ulong; //http://dev.mysql.com/doc/refman/4.1/en/ ... limit.html

Greetings, Bernhard

Hello,

The ENUM solution works, but BIT(1) don't. See my new patch for BIT(1).

Greetings, Bernhard

Hello Jan, the range check error in ZFunctions.pas ist fixed. :D In ZDbcMySqlResultSet.pas the range check error is still present. I cannot reproduce In ZVariant.pas the range check error at the moment. For FLengthArray[ColumnIndex{$IFNDEF GENERIC_INDEX}-1{$ENDIF}] range check can not work. FLengthA...

Sorry, I haven't made myself clear enough. I mean My proposal is to deliver (and test) the ZEOS project-sources are working with all checkings activated. While project development I switched on all debug checkings. But ZEOS crashes with these settings. The solution is to fix the code or as workaroun...

Hello,

I have an old MySQL database. The missing boolean field type ist implemented as TinyInt(1).
For newer MySQL Versions is the field type bit available.

So I agree to
Assume using the TINYINT(1) as Boolean type simply is wrong!

Greetings, Bernhard

Hello Jan,

Your patch looks fine.
But I found an other issue. The value for a boolean field can not stored as 'Y' or 'N' because the data type is TINY_INT.
Please look at my new patch.

Greetings, Bernhard

-> My proposal is to deliver (and test) the ZEOS project-sources with all checkings activated.

This is the right way to deliver common sources. I have attached a patch for this problem.

Greetings, Bernhard

I got error messages wrong field type boolean/smallint for MySQL/Delphi XE6 . I found no sources for getting the field type stBoolean.
I attached a patch for this issue. Can somebody test and submit it to the 7.2 branch?

Greeetings, Bernhard

The fix in ZDbcMySql.pas in revision 3565 > procedure TZMySQLConnection.SetAutoCommit(Value: Boolean); > begin > if AutoCommit <> Value then > //if AutoCommit <> Self.AutoCommit then > begin > inherited SetAutoCommit(AutoCommit); is the reason for not working adding or deleting records. I think the ...

Sorry, my mistake.

InsertRecord is not a procedure of TZAbstractRODataset.
This can without Delphi XE6 sources not work.

Greetings, Bernhard

Environment: XE6, MySQL I try to add an entry to a mysql table with InsertRecord. Nothing happens. No error message. No entry in the monitor logfile. Adding a new line in a TDBGrid connected to the same table works. I see the insert statement in the monitor logfile. What is the reason? Empty RowBuff...

MySQL: I got for long strings following error message:

'Column length too big for column ''Name'' (max = 255); use BLOB or TEXT instead'

Column length is multiplied by factor 6

I changed the order from tablePattern,schemaPattern to schemaPattern,tablePattern. I got previous a "table not found" error. The only one call of the function is in TZAbstractConnection.pas: GetTableNames('',Pattern,nil,List); My changes: procedure GetTableNames(const schemaPattern,tablePa...