Hello,
I think I have to use a write trigger to accomplish this task. Just curios if there is another method to update this field rather than messing around with the write trigger. I am concerned that because I have don't have the write.p just the write.r that I might be over writing...
Hello,
Anyone out there know how to find the lenght of a decimal field.
I tried this:
DEFINE VAR ckamount AS DECIMAL FORMAT ">>>>>>>>>9.99":U.
DEFINE VAR blklen AS INT.
ASSIGN blklen = LENGTH(ckamount)
I get the error message: Incompatiable datatypes in expression or assigment.
Later...
I have a user input data into 6 fields. Then I validate the data in the fields. Next step I create a temptable and assign the screen-values of the fields into the the temp table which I am displaying via a browse. My question is how do I just limit one record from being created in the temp table...
I have this code in a trigger and the return no apply seems to kill the trigger. Then basically I can't update my temp table. So if I put this validation in a frame I think it might work. I have multipile fields that I need refocus to if no data is entered into the fields.
field 1 no entry go...
Hello All,
I have a question regarding how to add in multipule input transactions into a temp table.
The approach I have been using is I set a variable to = 0 then I assign this value to one of the fields in the temp table. This works fine for the first record but there is a minor issue...
I trying to figure out how to clear all my input fields. I came across input clear but I am unclear how this would work. Anyone use this to clear out input fields.
I am trying to figure out how to convert a character value of a screen-value to an integer. Is this possible? I thought I read somewhere that screen-values are always character.
I have the query piece working however none of my data is getting into the temp table.
I should be creating the temp table then running the procedure for the query. Is my hangup due to the fact I am trying to assign my screen-values to the temporay table. I tried assigning the screen values...
I created my browse and used the freeform query. I assigned my screen-values to their temp fields they need to go into. I get the error
no table-name record is available (91).
I put in a Create table before my assign statements. Not sure what I am doing wrong here.
Thanks for your suggestions this helped me figure it out. I ended up making both comboboxes list items pairs so that I could assign the screen values from both combo boxes to variables.
Not sure I follow how to add the id's behind the description. I have tried using the item pairs but i thought was for list like a,1 b,2 etc not sure how to put the table names in the item pairs or is that even possible.
Thanks.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.