Devart Forums

So far I used MyDac 5 and yesterday I installed the newest version.

Thanks to the new version everywhere in all my programs where previously RefreshQuick worked flawlessly now there is an error:

> Timestamp field required
But there is timestamp field!

One example:

Sql:

> Select *,CONCAT_WS('-',INVOICE_PRE,INVOICE_YEAR,INVOICE_NO)Sz_sorszam
> from invoice
>
> order by INVOICE_PRE,INVOICE_YEAR,INVOICE_NO
The Update Sql parts are not filled.

Table structure (fragment):

> CREATE TABLE `invoice` (
> `INVOICE_AUTOINC` int(11) NOT NULL AUTO_INCREMENT,
> `INVOICE_PRE` varchar(20) NOT NULL,
> `INVOICE_YEAR` char(4) NOT NULL,
> `INVOICE_NO` char(10) NOT NULL,
> `INVOICE_TIMESTAMP` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
> `INVOICE_TIPUS` tinyint(4) DEFAULT '0' ,

This is very urgent, this afternoon I needed to produce a new version to a customer but in this circumstances I couldn't do anything, the program is full of error messages.

Hey Starhu,

Please change the definition of the timestamp field in the table from:
`SZAMLA_TIMESTAMP` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
To:
`SZAMLA_TIMESTAMP` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
This change should fix error messages you are getting.

Thanks,
Viktor

Hello Victor,

This works, thank you.

Hi Starhu,

Thanks for your reply.
I’m glad that your issue is fully resolved now and you can use all the features of our product.

Best regards,
Viktor