2007-05-02 09:25 PM
2007-05-02 09:31 PM
2007-05-03 10:30 AM
2007-05-03 11:09 AM
Matthew wrote:I'm not sure if I understand your problem exactly here, but there is situations when you need to use ( ) when you work with negative values.
2. When used as an argument in a VALUES statement. This is just a quirk which I get around by assigning the negative values to variables and putting those into the values list.
2007-05-03 06:00 PM
TurboGlider wrote:I haven't explored this fully. After I found the quick fix I moved on. But the situation is this:Matthew wrote:I'm not sure if I understand your problem exactly here, but there is situations when you need to use ( ) when you work with negative values.
2. When used as an argument in a VALUES statement. This is just a quirk which I get around by assigning the negative values to variables and putting those into the values list.
But because I don't now when your got your problem, I can't test it.
VALUES "for_example" -2, -1, 0, 1, 2Results in an error. Whereas:
n1 = -2 n2 = -1 VALUES "for_example" n1, n2, 0, 1, 2Works just fine. I believe it is because operations are not supported within the values list and it interprets the minus sign as part of a subtraction.
VALUES "for_example" (-2), (-1), 0, 1, 2
2007-05-03 08:22 PM
2007-05-04 02:26 AM
Karl wrote:Thanks Karl. That seems a little cleaner.
Yes, parentheses are the solution.
Karl
2007-05-04 08:28 AM
2007-05-09 08:32 PM
2007-05-10 03:21 AM