Results 1 to 4 of 4

Thread: Why did my SQL funtion just suddenly stop working.

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Feb 2009
    Location
    Queens, NY, NY
    Posts
    7,429

    Default 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
    ++++++++++++++++++++++++++++

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •