Start a new topic

'datetime' keyword is not coloured

[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

[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
[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
[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