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 :-(
Unidac 7.3.10 Delphi 10.2.3 error: MariaDB default values
-
- Posts: 10
- Joined: Fri 25 Jun 2010 09:00
- Location: Denmark
Re: Unidac 7.3.10 Delphi 10.2.3 error: MariaDB default values
For a quicker response, please the script to create any table with which the problem that you mentioned appears.
-
- Posts: 10
- Joined: Fri 25 Jun 2010 09:00
- Location: Denmark
Re: Unidac 7.3.10 Delphi 10.2.3 error: MariaDB default values
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.
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.
Re: Unidac 7.3.10 Delphi 10.2.3 error: MariaDB default values
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.
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.
-
- Posts: 10
- Joined: Fri 25 Jun 2010 09:00
- Location: Denmark
Re: Unidac 7.3.10 Delphi 10.2.3 error: MariaDB default values
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
Best regards Lars
Re: Unidac 7.3.10 Delphi 10.2.3 error: MariaDB default values
Thank you for the interest in our products.
When you get any results concerning this question, please let us know.
When you get any results concerning this question, please let us know.