2 Replies Latest reply: Apr 16, 2014 8:45 AM by rakesh sarangam RSS

    How to retrieve the last updated record froma table and displayit in textobject

      Hi all,

       

      AS per  the below attached excel file.. i am having a table with field names

      [database name],

           [Last successfull reload date time],

           ErrorDate,

           ErrorTime,

           QVWname,

           ScriptError,

           ScriptErrorCount,

           ScriptErrorDetails,

           ScriptErrorNo

      ...So what i wanted is that.. i want to get the QVWName and the database name as per the last updated  error time...in this case the errortime is 14-4-2014 12:15:43..............and this is what i need to display on a text object.

      So what i need in the output in the text object  is that:   ERROR OCCURRED IN DATABASE NAME:stflush AND QVWNAME:TitanExtract-InvJrnl.qvw... It will be very helpful if sumbody can help in solving this problem.

       

      Thank You