Search results for query: *

Hi friends, I need your help. I need to find out the week of the year. Does anyone have any query for that or know how to calculate it. For example if user passes any date then that query should return the week of the year. Thanks in advance.

Hi friends, I need a help in Discoverer report. My Report was working fine with this date format but when on this Monday my DBA upgraded the application with new version it started giving me an error. Error is An error occurred while trying to run the query. (Inconsistent or invalid data types...

Hi! can anyone help me in finding out the reason behind this cause. When I do select length(to_char('23456','99999.99')) from dual; LENGTH(TO_CHAR('23456','99999.99')) ----------------------------------- 9 it returns the length as 9, where as I am...

Hi! Can any one help me how to convert .rpt file into .rdf in developer 2000 6i. Thanks in advance, Anju

Hi friends, I am getting a problem in developer 2000 reports 6i. when I run the report in windows and try to save that in file, it create the file but when I open that in note pad, it seems it create the file in machine language. I passed destination type= ‘File’ and destination name=...

Hi Friends, I have one problem. There is a data base block and its multi line displayed item property is set to true (4). In post query I have written a code to display one of the items (phone number) in a format ((xxx)-xxx-xxxx). Phone number is base table item and its data type is number in...

Hi Friends, I have few queries related to Oracle database. Can anyone help me out? 1. How can we interact with two sessions in oracle database? 2. Can we pass array as a parameter in procedure and also can we pass cursor as a parameter in procedure? how? 3. Is it possible to lock row/rows in a...

hi friends, i have some questions: 1. I have created a screen for capturing client detail information but I am having a problem when two users query for same company detail. It blocks the other. I know the reason why it blocks but i am not getting how to display message (like some one is already...

Hi friends, I have to create a report to track if anyone worked on any work order after 5:00 PM or on weekends. Suppose I worked on work order till 5:30 then in report it should show that time exceeded or if someone has worked on weekends then it should say the its Sunday or Saturday (something...

Hi friends, Can any one tell me how to send a mail through forms like notifying any customer by sending e-mail to them? Is there any facility in developer2000 forms? If yes, the how can I use it? Thanks in advance, Anju

Hi friends, I have a database item called start_time with data type date and this is non displayed item in form. There is another item called st_time (which is not database item) which take the value from start_time in hh24: mi format(st_time = start_time), data type is datetime and this is...

Hi Friends, I need help in one update statement. There is a table called wo_assigned_person(columns: work_order, person_name). Where there can be single workorder number with 1 or more person name. Basically that means a single workorder can be assigned to more than 1 people. What I want to do...

Hi friends, Is there any way to display the description of populated list item as user scrolls up or down in list box. Suppose there is a list box, which contacts order number and create date. As user scrolls up and down in a list box, it should display corresponding detail description of that...

Hi Friends, I need a help. I am trying to execute a query based on my criteria. Like in new-form-instance trigger I have written: select start_time into p_stime from time_sheet where END_TIME is null and employee_id = (select employee_id from employee_detail where user_id = user)...

Hi friends, I have a very weird problem. I am using 9i forms at home and every time whenever I compile the form and try to run it, it gives me error: “FRM-30087: Unable to create form file C:\forms\test.fmx.” But as I save it with new name, for first time it runs perfectly but next time when I...

Hi friends, I need a help in displaying list of value. Is it possible to display a list of value in a list of value? I mean if suppose there is list of value of breakfast, lunch, dinner and when user select suppose breakfast then automatically its sub should pop up example break, coffee, tea...

HI friends, In my forms what I have to do is if user types initial 3 letters of company name or whatever then it should bring all company name matches with that three letters. Suppose company name is computer dept. ltd, communication ltd. etc, so when user types “com” in the company_name field...

Hi friends, Can anyone tell me is it possible to change the insert message in form programmatically or any other way or to get rid of that message. I mean as we insert a record, it gives us message frm-XXX : 1 Record inserted....some thing like that. I want to change that message to some...

Hi friends, I have declared a item multiline property true. When I am trying to navigate that items previous item, any key doesn’t work. I have also written a key-up and key-down on form level to navigate next item and previous item. Trigger works fine for all items except that item whose...