Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. LimonaM

    replace function

    Hello. How must i use function replace so i can in one item in my form replace ',' with '.' ? Users are writeing nubmers and some write ',' and some '.' It has to be '.' Now i want that every time someone write ',' it would be replaced by '.'. Help please Thanks
  2. LimonaM

    Problem with items

    Thanks
  3. LimonaM

    Problem with items

    I want to change just one item not row. In my example i showed just one item in row, but i have many. I need to change just one item
  4. LimonaM

    Problem with items

    I have one item on my form, which is presented 15 times. How can i change color of just one item? Example: table users: users ------ a b c d e f Now i want to change the color of d - how? I used set_item_property, but then the color of all those items is changed!
  5. LimonaM

    How can i get rid of messages in runtime

    I'm anoyed of one message in runtime. What can i do so the message wouldn't appear? I use on-message trigger: DECLARE errnum NUMBER := ERROR_CODE; BEGIN IF errnum = 40401 THEN :GLOBAL.chk := 'y'; END IF; END; but it doesn't help in this case! Is there some other solution?
  6. LimonaM

    how to put 0,001 into item and not .001

    Item tyoe is char, because there aren't allways numbers. I just need the leading null(0).
  7. LimonaM

    how to put 0,001 into item and not .001

    how to put 0,001 into item and not .001? Where can i and how describe mask for numbers so the first zero won't be erased?
  8. LimonaM

    on runtime message

    hello. How can i disable message FRM-40401: No changes to save? I have many records and some of them are changed some not. Now i don't want to press enter every time there is no change. I have trigger on_message and on_error but i stil get this message. Help, please.
  9. LimonaM

    next tab page

    Which trigger would respond when i go to next tab page with mouse? I click on next tab page and something would have to happened. Which trigger?
  10. LimonaM

    Form parameters to reports

    Hello. I have a form with a button. When i press it, i want that something can be printed out. How can i some parameters (from form items) put into report (i have one report form when i press the button before i print) from forms? Thanx
  11. LimonaM

    How can i change cursor color

    ?
  12. LimonaM

    why does my form closes when i just press on mouse or keyboard key

    Hello. Sometimes when i just click with mouse or press some keyboard key in my form the form closes. It just ends!!! It looks like some bug. Are there some problems with some triggers. Tell me please. Thanks
  13. LimonaM

    execute_query

    Hello. I would like to know, when i jump to one block and put into one item something through trigger, that then execute_query would execute? And how can i ger rid of the message: would u like to save ... Yes/No/Cancel Thanks
  14. LimonaM

    execute_query

    Hello. I would like to know, when i jump to one block and put into one item something through trigger, that then execute_query would execute? And how can i ger rid of the message: would u like to save ... Yes/No/Cancel Thanks
  15. LimonaM

    no-data-found problem

    There is no error, no constraint. It just allways puts me into the item where 'SA' or nothing (null) should be. SQL sentence is in trigger - When-button-pressed. SQL sentence looks if record has 'SA' approved. If it has it writes it in item and then copy this 'SA' to another item and commit. The...
  16. LimonaM

    no-data-found problem

    I did and it's still the same!
  17. LimonaM

    no-data-found problem

    Hello I have SQL sentence in my forms. And can get from it two results. 'SA' or nothing. When there is 'SA' i can commit my rows and go to the next record. But when there is nothing i can't commit and i allways find myself in the item so i could write something in. But i mustn't. How can i...
  18. LimonaM

    Reports in froms

    Yes it worked - i used RUN_REPORT_OBJECT. Thanks
  19. LimonaM

    duplicated records

    Need some help with records There are 2 blocks in my form. In first there are all records i have. In the second are records which i can add to first block. Some records which i want to add are already in the first block. How can i, when i want to add some record which already exist, display...
  20. LimonaM

    How to print reports on forms

    when i press one button.

Part and Inventory Search

Back
Top