||Re: DATE VALUE in SQL
||Fri, 16 Nov 2018 12:38:51 +0200
On 2018-11-16 09:16 AM, Mustansir Ghor wrote:
> Dear Wian
> Thanks. Yes it worked except for numeric field rate. Here literal value is accepted but not variable.
Strange. Did you get any error msg ? If so, what was it.
Either the table field is not numeric or the value is not numeric but
something like a double.
To find out use ?type("mrate")
If the answer is not numeric, you can add 0.00 to the variable and then