Search results for query: *

Hello, I have a cross-tab table with a formula (@question) as one of the columns. The formula is displaying the question number - ToText ({QUESTION.QUEST_NUM},0). The question numbers however are not sequential numbers. For example, they're starting from 15 on (15, 16, 17, 18, 19, ...). I...

Hello everyone, Sorry - I've recently submitted the same question but was away for a week and never had a chance to reply to the original thread. This is my script: SELECT tv.pm_name, tv.tech_name, empl.f_name, empl.l_name, empl.address, empl.phone, empl.fax FROM task_view tv...

Hello everyone, I have the following select statement: select comp_dir, comp_poc, comp_role, empl.add, empl.phone, empl.fax from company comp, employee empl where comp.comp_id = empl.company.id and comp.active_flg = 'Y'; This select gives me the address,phone, and fax for...

Hello everyone, I have a crystal report in version 9 where I am pulling client information. Basically, these are the things it's pulling: company name (comp_name) company phone (comp_phone) company address (comp_addr) company representative (comp_rep) company point of contact (comp_poc) I...

Hello everyone, I have an existing report that has a cross-tab table in it. On the column part of the table, it's pulling question numbers that are not archived in the database table. For example, it's pulling, 7, 8, 9, 12, 15 based on their active flag in the table. I would like to change...

Hello, I have a report in Crystal 9 that has a field which pulls question numbers from the database. For example the database would have the following information in the table called xyz. question # question archived 1 What is your name? Y 2...

Hello everyone, I recently noticed that all my tables and views were missing when I go to open my ODBC in crystal report version 9 client. The only things that display under the ODBC are stored procedures. Has anyone ever seen this issue? Thanks, sql99

Hello everyone, I have a CR in version 9 that I repointed to a different ODBC source. After proceeding to fix the report, I execute the report via the client. The field that is <LONG> (captured as "memo" type via the client) is being truncated to only the first character. For example, "test"...

Hello everyone, I saved a crystal report from version 8 to version 9 and upon trying to execute it(run it), I get the following messages - 'The database file "abc" has changed. Proceeding to fix up report!'. I click OK for all of them and get a message saying that the database is up to date...

Hello everyone, Can someone please tell me how to write javascript code to detect if the user is using the IE browser? If they are, to continue w/the code. If not, to display an error message = "Your browser is not supported". Thanks in advance for your help. sql99

Hello everyone, Sorry but this is a newbie question. I have several .java class files that currently use ftp in them. For example a few lines in the code are: ftpConnect(server) ftpLogin ftpSEtDir(Dir) I am required to change the class file to use "sftp". Would that mean simply changing...

Hello everyone, I have a sql script with the following content: SPOOL C:\temp\union.lst -- ((SELECT pers_id FROM person WHERE pers_id IN (SELECT pers.pers_id FROM person pers, employee emp WHERE...

Hello everyone, I have the following statement: DELETE FROM emp_record WHERE EXISTS ((SELECT 'X' FROM emp_record emp, employee_type empt WHERE emp.emp_cat in ('Recep', 'Secr') AND empt.emp_stat in ('Mech', 'Elect')...

Hello everyone, I have the following select statement" (SELECT pers.pers_no pers_id, MAX(decode(substr(TRIM(pers.pers_job), 1, 5), 'SALES', pers.annual_salary)) sales_sal, MAX(decode(TRIM(pers.pers_job), 'RECEPTIONIST', pers.annual_salary)) recep_sal...

Hello everyone, Sorry to keep asking questions but I need help with a select statement. I have the following select statement: SELECT distinct(pers.pers_id),sta.per_status, add.per_address, job.job_category FROM person pers, status sta, address add, jobs job WHERE...

Hello everyone, I have a create view script that consists of 5 select statements similar to the one below. The select below takes about 40 seconds to run. Is there anything I can do to speed up these queries? From my understanding, I cannot use indexes on views? I appreciate any help I can...

Hello, I have the following update statement: UPDATE person per SET per.start_date = (SELECT emp.start_date FROM employee emp WHERE per.ident = emp.ident); Can you please tell me why this update statement isn't working? It's...

Hello, I have the following script: SELECT abc.employee, fdb.workday, abc.name, vew.program FROM employee abc, schedule fdb, group vew WHERE emp.prog = 'TEST' AND vew.plan in ('ABC', 'ABB', 'AAB') AND vew.date = to_date('03/15/1999', 'mm/dd/yyyy') AND sum(fdb.hours)...

Hello, I have the following in my <head> section: <STYLE TYPE="text/css"> <!-- H1 { color:#ffdd38; font-size:16; font-style:italic; } H2 { color:#ffffff; font-size:16; font-style:italic; } --> </STYLE and I have the following in my table section: <TABLE...

Hello, I have a few text input boxes that I would like to left align so that it looks cleaner. Below is what I currently have and it's centered instead of left align because everything else is centered. Can you please help? I would like the Name: and Telephone: to be moved over to the center...