Hello,
Anybody know a solution to this?
I am trying to set a currency in SQL table ‘Credit’ The column in question is defined as 15 digits and 2 decimals (#.##).
The script looks like:
Call result.SetValue(“Credit”,0)
When query is executed, the value is reject because 0 doesn’t match #.##.
I have already tried Ccur(0) and Format(0,“#.##”) but Ccur(0) also returns 0 and Format turns up as string, which are both rejected by the SQL server.
There must be a better solution then using
‘INSERT INTO’ query, there are too many ’ and ,
Anyone?
Thanks, AceIndy