Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    Dhaka,Bangladesh
    Posts
    86

    Unanswered: SLV is undefined

    Hi experts,

    How can i use runtime column value ? I have tried following and faced error. Here for logging_time = sDate is giving error. I want to use the runtime sDate value for the query for a subquery later. Please help.



    Select logging_time as sDate,DBINFO('utc_to_datetime', logging_time) as sDateTime
    From tempTable
    Where logging_time = sDate


    Error: SLV is undefined
    hello

  2. #2
    Join Date
    Apr 2007
    Location
    Jundiai / SP - Brasil
    Posts
    311
    well... this example don't make sense for me...
    And, this example never will work...

    I don't know, maybe you looking for something like this :
    Code:
    Select logging_time as sDate,DBINFO('utc_to_datetime', logging_time) as sDateTime
    From tempTable a
    Where logging_time = (select b.logging_time from tempTable b where b.loggin_time = 134143242 )
    There is no logic on this code, are just a syntax example....
    ________________________________________
    César Inacio Martins
    Jundiai / SP - Brasil
    http://www.imartins.com.br/informix - em Português
    http://www.imartins.com.br/informix - English (translated by Google).
    ________________________________________

Posting Permissions

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