SQL Syntax color

[expired user #8735]'s profile image [expired user #8735] posted 9 years ago in General Permalink
character bad $var coloring in variable
character _var is ok

BEGIN
#Routine body goes here...
DECLARE $deltadate int;
DECLARE $deltapart int;
DECLARE $min date;
DECLARE $max date;
SET 
$deltadate=DateDiff($Finish,$Start)+1,
$min=If($Start>$From,$Start,$From),
$max=If($Finish<$To,$Finish,$To),
$deltapart=DateDiff($max,$min)+1;
RETURN Round(If($ID,myPrice($Value, $ID, $Start) ,$Value)* $deltapart / $deltadate,0);
END
ansgar's profile image ansgar posted 9 years ago Permalink
SynEdit does not detect such variables. It's just the dollar character which is colored because it's a key character in some way.
[expired user #8735]'s profile image [expired user #8735] posted 9 years ago Permalink
In photo is ok and bad
https://drive.google.com/file/d/0B9QmlmNAp7klM1pNVF83ZE92cU0/view?usp=sharing" alt="" />
[expired user #8735]'s profile image [expired user #8735] posted 9 years ago Permalink
https://drive.google.com/file/d/0B9QmlmNAp7klM1pNVF83ZE92cU0/view?usp=sharing
ansgar's profile image ansgar posted 9 years ago Permalink
"start" and "from" are SQL keywords, and therefore get colored like such (blue).
[expired user #8735]'s profile image [expired user #8735] posted 9 years ago Permalink
Alternative program like navicat is simple syntax coloring but right
Heidesql is nicer syntax coloring but not right
https://drive.google.com/file/d/0B9QmlmNAp7kldnhpVnFCQU4xbFU/view?usp=sharing
[expired user #8740]'s profile image [expired user #8740] posted 9 years ago Permalink
SynEdit does not detect such variables. It's just the dollar character which is colored because it's a key character in some way.


______________
watson

Please login to leave a reply, or register at first.