Why did my SQL funtion just suddenly stop working.
I have a Function thus:
Code:
Dim MyData as Global
let myData = SQL("select top 1 [svalue] from [tSysdflt] where (lower(rtrim([key])) = 'dateformatstring')")
return myData
which returns output
select top 1 [svalue] from [tSysdflt] where (lower(rtrim([key])) = 'dateformatstring')
Inquiring minds would like to know why.
from SSMS the result of the query, as exopected is "dd-MMM-yyyy"
Last edited by Michael Mullan; 2-Jul-2018 at 03:30 PM.
Reason: /code
Michael Mullan.
Danes Bridge Enterprises.
++++++++++++++++++++++++++++
There is just today. Tomorrow is a concept
that is mostly theoretical. -- GM Wylie
++++++++++++++++++++++++++++