Recent content by nickty

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

thanks very much, that has worked great

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

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!

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!

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

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

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

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

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

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.

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

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

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.

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