Subject Re: DATE VALUE in SQL
From WJS <warra@nowhere.com>
Date Fri, 16 Nov 2018 12:38:51 +0200
Newsgroups dbase.getting-started

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
try again.

Wian