how to check whether parameter are initialized?..I'm accessing Db and few columns returns null. when i save it in parameter(using correlation option) and later use for comparison if throw error saying its not initialized? how do i solve the problem?
explicitelly assign the returned value to a local variable you create, I think it's possible, so define this variable to NULL (without quote) and if the DB return null the variable is initialized (as it is not overwritten with DB result NULL), and if returned value is defined, the lrd_assign function will set the varaible to the returned value.
I did try to declare variable and use variable in lrd_save_col, it throws error at run time saying invalid argument. I have to use only parameter . Even though this parameter is declared and intialised before assigining values in lrd_save_col, after this statement (lrd_save_col) execution , when i try to lr_eval_string with the param name it throws error saying parameter not initialised. When i say null in Db it mean, columns has no value, its not that we are inserting NULL value to column.Any further help will be appreciated.
i'm not getting much info on LRD_CUSOR in help index. i didn't declare variable of LRD_CURSOR. i tried with variable of type char. when i said i'm saving value of database col to parameter it is though , Grid->select col->right click->create corelation. It adds new statement lrd_save_col(). When Database col contains no values , this parameter is not assigned. So when i evaluate by Lr_eval_string(param name) it was throwing error. However i found soln to this problem by declaring parameter lr_save_string("\0","Saved_LABEL4A"); and saving database coln value as lrd_ora8_save_col(OraStm7,9,1,0,"Saved_LABEL4A") . Whenever coln contains no value, it don't return anything nor aborts with error message. Please do let know other better approach. Thank you for your time in answering my q.