Search results for query: *

Thanks. I wasn't thinking. I forgot to expand the query window and only saw 2 queries.... Thanks.

Hi Duane, I'm reviewing your At Your Survey Statistic Reports and noticed that you used qselQstnTextRspnsxCount. How can I review this source? Thanks.

FYI, I just completed union query for all the questions like the way you recommended and received an err with "Query is too complicated". It didn't allow me to save it as one query so I made it to two query. I guess there is limitation of union query. Thanks.

Yes, I have records in my table. What is next step after you do union query all these answers? Thanks.

Yes, I know. I didn't like the fact that I have to repeat the same steps to create same results for all different questions. What do you recommend? I guess I need to restart my process. Do you have any steps or process so that I can accomplish what I'm looking for? Thanks.

Hi dhookoom, No, It is not too late to change my table structure, and I'll be more than happy to change it if I need to. What do you recommend? But I don't understand why I need to change it since this table collects only answers. I briefly looked at your sample demo and it is very...

Hi Remou & dhookom, Currently, this table contains all answers and it looks like below and ID is primary key along with doc_date: ID,doc_date,RN1,RN2,RN3,RN4...RN50+ 11, date,Yes, No, N/A,Yes... 13, date,No, Yes, , Yes... Thanks

Hi all, I have created queries (50+) to capture below information and these information is in one single table. Only thing different is column name. I used query option, because I have not figured it out different way. SELECT Sum(Abs([RN1]="Yes")) AS Yes...

The TheAceMan1 & MajP, Thanks for the help. It works! Thanks bunch!

Hi TheAceMan1, I tried Switchboard already, but no luck so far. It let you open the form but I wasn't able to cursor to focus on specific tab#. Can you be provide detail step. Thanks.

I'm new with forms. I have couple of forms and I need to be able to navigate different forms, pages, and tabs based on which command button is clicked. Form1: Page1...page5, page3, tab1...tab10, cmd1...cmd3 Form2: Page1...Page5, page3, tab1...tab10, cmd1...cmd3 Tried several options but so...

Hi Turkbear, In getfulldt function, I tested both format but results are same. It truncates and do not display hours and minutes. y := to_date(x, 'hh24mi ddMonYYYY') and y := to_date(x, 'hh24mi dd/Mon/YYYY') See below sample data and when I tested with your suggestion and I received an...

Santa, My vendor is using "Oracle" as their sales pitch. All of their application is developed in some legacy product and transfer the data to Oracle. Bottom line is that we made enough complaints but so far no luck. I just have to deal with it.

Hi DT, Thanks but I already tried that option and results are still same. select data, to_date(getfulldt(data)) visitdate from test ----- 2333 17Nov2005 17-Nov-2005 12:00:00 AM Thanks.

Hi all, Yes. BJCooperIt is correct. We cannot control on the front end. I just have to deal with it. I requested modification of application, but it may take years. Bill--I don't have permission to create triggers. FYI, I don't have permission to access tables. I'm only allow to access...

Sata, Thanks. I questioned these problems in the past about data quality issue but so far no luck. Majority of users don't deal with the data quality as long as it is documented in the system. I hope the vendor will make changes to the product soon but I'm not counting on it. I wish I can...

Hi Santa & Bill, I totally agree with you guys. I wish I have control over when we collect the data. Unfortunately, I don't have that option. We are using proprietary product and ALL of data elements are in varchar2 format. Bottom line is that I just have to deal with it. Thanks.

Hi BJCooperIT, Thank you for your information but I'm getting 'ORA-01722 Invalid Number' error. FYI, some folks are hand jamming the data and data is not consistent. Thanks.

I have a field that collects visit date & time but it is stored in varchar2 format 'hh24mi ddMonYYYY' and I thought this function will solve the problem but it doesn't. create or replace function getfulldt(x in varchar2) return varchar2 is y Date; begin if x is y := to_date(x, 'hh24mi...

Gunjan, That is what I'm looking for. Thank for your prompt response. :-) Kokiri