Unidac 7.3.10 Delphi 10.2.3 error: MariaDB default values

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
LarsGeisler
Posts: 10
Joined: Fri 25 Jun 2010 09:00
Location: Denmark

Unidac 7.3.10 Delphi 10.2.3 error: MariaDB default values

Post by LarsGeisler » Fri 09 Nov 2018 10:17

Hi,
when connecting to MariaDB 10.3.10 with Unitable and the table has TIME values with a default value, and TUnitable.Options.DefaultValues = true
then you get the error:" Wrong time format at field <fieldname>"
This happens even
In the release notes for UniDAC 7.3.10 it is stated:
* Bug with filling default values in MariaDB 10.2.7 and higher for Delphi 7 and older is fixed
but it seems it lives on :-(

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Unidac 7.3.10 Delphi 10.2.3 error: MariaDB default values

Post by ViktorV » Fri 09 Nov 2018 10:23

For a quicker response, please the script to create any table with which the problem that you mentioned appears.

LarsGeisler
Posts: 10
Joined: Fri 25 Jun 2010 09:00
Location: Denmark

Re: Unidac 7.3.10 Delphi 10.2.3 error: MariaDB default values

Post by LarsGeisler » Fri 09 Nov 2018 11:06

Sorry, something went wrong when i posted.
The tabel is defined as: (taken from create-kode in Heidisql on MariaDB)

CREATE TABLE `mekaniker` (
`Forretning` VARCHAR(10) NOT NULL DEFAULT '',
`MekID` VARCHAR(10) NOT NULL DEFAULT '',
`Navn` VARCHAR(30) NOT NULL DEFAULT '',
`Afd` VARCHAR(12) NOT NULL DEFAULT '',
`UdlejStartTid` TIME NOT NULL DEFAULT '04:59:30',
`UdlejSlutTid` TIME NOT NULL DEFAULT '20:00:30',
`webbook` TINYINT(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`Forretning`, `MekID`)
)
COLLATE='latin1_swedish_ci'
ENGINE=MyISAM
;
Problem is the two TIME fields Udlej...

I have a very small projekt to demonstrate the error with a Uniconnection, Unitable and a few Dbedits and a DBnavigator.
The error appears even when changing Active on the Unitable to true in the Ide.

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Unidac 7.3.10 Delphi 10.2.3 error: MariaDB default values

Post by ViktorV » Fri 09 Nov 2018 12:58

Unfortunately, we cannot reproduce the issue using the information provided by you.
To understand the cause of the issue, we need a test sample, in which the issue is stably reproduced. As soon as we get such a sample and if the issue cause is due to our product code, we will try to fix it in the shortest possible time.
Therefore, please compose a small sample demonstrating the described behavior and send it to us via form e-support: https://www.devart.com/company/contactform.html. Also, please specify the exact version of the used IDE.

LarsGeisler
Posts: 10
Joined: Fri 25 Jun 2010 09:00
Location: Denmark

Re: Unidac 7.3.10 Delphi 10.2.3 error: MariaDB default values

Post by LarsGeisler » Fri 09 Nov 2018 13:26

Sorry to hear that, but I will continue investigating in my end, and come back when I have a stable sample that shows the error.
Best regards Lars

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Unidac 7.3.10 Delphi 10.2.3 error: MariaDB default values

Post by ViktorV » Fri 09 Nov 2018 13:28

Thank you for the interest in our products.
When you get any results concerning this question, please let us know.

Post Reply