'datetime' keyword is not coloured : DbVis Software

a

anonymous

started a topic over 11 years ago

[This topic is migrated from our old forums. The original author name has been removed]

Hi,
This has bugged me for a while.  The 'datetime' keyword is never formatted as blue in the sql editor.  It should be a standard keyword like 'numeric' or 'int'.  They are formatted as blue.  In the sample below 'datetime' is black but 'int' and 'numeric' are blue.

Thanks,
Gary

CREATE PROCEDURE pr_b200_annualize_policy_fee
    @div_ky             int,                            /* division */
    @premium_due_date   datetime,                   /* date to annualize to */
    @ann_fee                numeric(13,4)   output, /* annualized premium */
    @last_sweep         datetime

Hans Bergsten

said over 11 years ago

[This reply is migrated from our old forums.]

Re: 'datetime' keyword is not coloured

Hi Gary,

Thanks for reporting this.

You didn't say which database type this is for, but it ail be highlighted for SQL Server, Sybase ASE, Informix and MySQL in the next maintenance release. If you know of other databases that support DATETTIME, please let us know.

Best Regards,
Hans

a

anonymous

said over 11 years ago

[This reply is migrated from our old forums. The original author name has been removed]

Re: 'datetime' keyword is not coloured

Thanks Hans,
We primarily use Sybase and SQL server and it does not show the colour in either.
Gary

Roger Bjärevall

said over 11 years ago

[This reply is migrated from our old forums.]

Re: 'datetime' keyword is not coloured

Gary,

Just to inform you this is now fixed in the 9.0.9 version.

http://www.dbvis.com/download/

Regards

Roger

How can we help you today?

'datetime' keyword is not coloured

anonymous

Hans Bergsten

anonymous

Roger Bjärevall