Yaa! Through query i tried for single records.......and it worked fine i mean the results were correct!
But its so strange that a logical field returns blank value in browse!! But when the same function when ran on mgeditor with output being displayed, it showed either yes/no only!
I am not sure whether this is the correct place to ask this question but still asking.
I had written a function in sales order browse which was suppose to return a logical answer. Following is the function:
function get_soc returns logical(input domain as char,input nbr as...
My question is that I have a .out file generated through Cim program. In my Cim program i am just checking the .out file by opening it to check if there are any errors(I know .out should not actually have any errors but still). So i use the following :
DEFINE VARIABLE lvc_error AS...
I am writing a CIM program. In that i have item,site,supplier,startdate as primary unique. So what i have to do is that when the input file to the CIM is provided, check if the records provided in the file with the primary unique combination already exists in the table. If the...
Can someone please provide me the differences between the repeat block and do block and when to use what!
I had read somewhere that repeat provides e.g transaction management and default frame management whereas do block doesn't.
Also , why is it recommended to have a single...
I understood a bit from your answer. But still i have few doubts.
I got the point that FIND is to be used only if we know we have a unique record(by providing complete index).
But then if i am not sure whether i have only a single unique record, how should i check that? using for first /...
I know my post could be quite annoying coz there are many and always asked questions about this topic.
Hi Tom i read your articles and few other on find and for statements.
But i am still confused with these.
So can you folks please help me understand a bit in detail as to how...
I have a doubt. I have a field in database that is character responsible for storing Account number. Now what i have to do is that when i enter some value for this field for e.g 00AVRT345, i want to store this value as AVRT345. If it would had been just to display it, it was easy by using...
I have a doubt which may sound to be strange but since I am unable to resolve it after attempts, I am posting this.
I have a decimal field in my schema defined with FORMAT ">>9.99" that means that the field can take values upto 999.99(i.e upto 3 places before decimal).
So when I...