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!

Register Log in
  • Congratulations derfloh 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. nickty

    problem with Y/N flag on mulit-record block

    i have a block with 5 items and 6 records per item. One of the items is a y/n field. I want to prevent the user from entering Y twice, ie if record 1 says Y, no other record can. How can I prevent this from happening. i've tried lots of solutions, but because there are 6 records per item...
  2. nickty

    Weeks Between

    thanks very much, that has worked great
  3. nickty

    Weeks Between

    Hi, I'd like to find the number of weeks between 2 dates ie start_date 1st-Aug-2002 end_date 31st_July-2003 How do I work out the number of weeks between these 2 dates??? thanks for your help
  4. nickty

    Being thick - set checkbox property

    thanks all ...MissJules, you are correct, i was trying to specify the 'value when checked' to either 4, 5 etc. However, I have changed the form so checkboxes are either Y or N based on data returned from d/b. thanks all for your help, it is now working great!
  5. nickty

    Being thick - set checkbox property

    thanks, but they are not y or n. the data returned will be a number from 1 to 12, so if the cursor returns, for example 4 and 5 I want to set checkbox 4 to 4 and checkbox 5 to 5, if you see what I mean!
  6. nickty

    Being thick - set checkbox property

    Hi, I'm being a bit thick, but can't work out how to set a checkbox either checked or unchecked programatically. I have 12 non-database items on my form. I have a cursor which is returning some data from d/b, and want to set 1(or more) checkboxes to checked depending on data returned. I've...
  7. nickty

    Master-detail Form

    Hi, I wondered if anyone could help? I have a master detail relationship, and the detail contains year. This table will have values for previous years, next year, and the current year. How do I get the form to display the CURRENT year, but allow users to scroll up to next year or down to...
  8. nickty

    ANSI joins in Forms Developer 9i

    Hi, just a quick question, Is it possible to write ANSI joins in Forms Developer 9i? eg: SELECT ename, dname, dept.deptno from empa INNER JOIN dept ON dept.deptno = empa.deptno thanks
  9. nickty

    ANSI Joins in Forms Developer 9i

    Hi, just a quick question, Is it possible to write ANSI joins in Forms Developer 9i? eg: SELECT ename, dname, dept.deptno from empa INNER JOIN dept ON dept.deptno = empa.deptno thanks
  10. nickty

    How to reference user in Initial Value in Property Palette

    Hi, just a quick question, and thanks in anticipation! I know that $$DATE$$ in 'initial value' shows the date on the form, but I want to know how to show the user as the initial value. I have guessed at $$USER$$, but that is incorrect. Does anyone know the correct syntax? thanks
  11. nickty

    #IERR error

    sorry, perhaps the brackets aren't right, I am trying to divide the whole lot by 2: ((value2-value1)+ (value3-value2))/2 where .... I think the problem is the where clause, and the fact I am doing a calculation on a calculation. any ideas? thanks.
  12. nickty

    #IERR error

    Hi, I have a BOb report where I am trying to calculate the following; I have created the following cross tab with codes down the left side and years across the top, the cross tab is populated by rates per code ( a variable i have created by dividing 2 values): 1999 2000 2001 2002 1...
  13. nickty

    Prompt in freehand Sql

    I am new to BO. I am amending some reports in BO which were created using freehand sql. I need to include a prompt in the report. At the top of the sql statement i am typing accept dept prompt 'Enter dept:' then the select statement then.... and a_dept_code = '&&dept' BUT BO throws up an...
  14. nickty

    Sending email - Oracle 8.1.6

    I have read the FAQ - but as I am a complete novice- it does not make much sense to me. Do I create the procedure first and somehow call it by a trigger? Any help is appreciated.
  15. nickty

    Sending email - Oracle 8.1.6

    I am building a 'fault call' database using WebDB 2.2. I need to automatically send an email to one address if the fault call is 'overdue', ie should have been completed in one day and has not. I have used the desc utl_smtp command from Sql+ - so think it is installed. I have no idea at all...
  16. nickty

    User log-in and trigger

    Hi I have constructed a form(using WebDB) which will be used by 20+ users in 10+ offices. Each has their own unique log-in. There are fields on the form for "logged_by" and "office_code". Is it possible (somehow) to capture the log-in and write a trigger that automatically...
  17. nickty

    User Log-in and Trigger

    Hi I have constructed a form which will be used by 20+ users in 10+ offices. Each has their own unique log-in. There are fields on the form for "logged_by" and "office_code". Is it possible (somehow) to capture the log-in and write a trigger that automatically inserts values...
  18. nickty

    Alpha Lookup

    Thank you for your reply - but it does not make much sense to me! I am using WebDB(but used this post as I don't get any replies using that forum) and thought that Developer is similar enough. Perhaps for this particular query WebDB is too different? ps I am a conversion computing student on...
  19. nickty

    Alpha Lookup

    Hi My application contains a number of LOVs. Some of them are large - containing office names and user names etc. There does not seem to be any alpha lookup facility - does anyone know a way to get round this - as it is a problem as users are going to have to scroll through a large amount of...
  20. nickty

    PLEASE HELP - Trigger for Time Difference

    You have been a great help - I am getting ambitious now - I am now trying to enter a trigger which when the TIME_TAKEN field is completed the status of the job is automatically 'closed'(just recording the string 'closed' to the database). I have a LOV which has a number of selections - the...

Part and Inventory Search

Back
Top