Search results

  1. V

    Updating 1 field in an Existing Record

    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...
  2. V

    How do I find out the length of a decimal field

    Thanks Guy before I could write about the issue the decimal point. Andre posted his solution. Thanks a bunch.
  3. V

    How do I find out the length of a decimal field

    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...
  4. V

    How to add multipule input transactions into a temp table.

    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...
  5. V

    How to add multipule input transactions into a temp table.

    I see how all the records are being put into the temptable at the same time. How do I just input one record at a time.
  6. V

    message "how do i return focus to entry Field".

    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...
  7. V

    message "how do i return focus to entry Field".

    Do I have put this in a frame?
  8. V

    message "how do i return focus to entry Field".

    how do I return focus to a field after I message the user to enter input.
  9. V

    How to add multipule input transactions into a temp table.

    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...
  10. V

    Temp Table question

    How do I put more than one record in the temp table?
  11. V

    Question about input clear

    disregard.
  12. V

    Question about input clear

    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.
  13. V

    how to convert screen value to int.

    Thanks man Input Value worked.
  14. V

    how to convert screen value to int.

    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.
  15. V

    Temp Table question

    Thanks I got the data in the temp table. I basically had my assigns backwards... Doh...
  16. V

    Temp Table question

    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...
  17. V

    Temp Table question

    I am having a little trouble creating the procedure to open the query for the browse. Is this a simple thing?
  18. V

    Temp Table question

    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.
  19. V

    cscombox box drop down

    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.
  20. V

    cscombox box drop down

    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.
Top