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.
URGENT PROBLEM : in the new version RefreshQuick error
Re: URGENT PROBLEM : in the new version RefreshQuick error
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
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
Re: URGENT PROBLEM : in the new version RefreshQuick error
Hello Victor,
This works, thank you.
This works, thank you.
Re: URGENT PROBLEM : in the new version RefreshQuick error
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
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