Search results for query: *

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

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

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

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

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

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

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

I wondered if anyone can help - I have been working on this trigger for 3 days now - with no luck. I have two fields TIME_RESOLVED and TIME_STARTED - all I want to do is take one from the other and put the value in TIME_TAKEN field. The trigger 'works' after a fashion - but will only insert...