Search results for query: *

I need to set Dos Environment variables in PL/SQL. Can anyone let me know how to do this? Thanks

Can anyone tell me how to determine which version of the Oracle8i client I have installed, as when I try to instal the ODBC driver from the CD it says that it cannot be installed on a 7.x or 8.0.x client?

I am writing a function that accepts the column name from all_tab_columns for any table and select the column data using this name. eg get the column name account_number which i know is in the accounts table, from all_tab_columns. I then want to select account_number from accounts. If I just...

I am trying to tidy up the users on the Oracle 8i server. Is there a way that I can find out when a user last logged on? The server is taken offline each night for an acrserve backup, so any session information before this seems to have gone.

I got the above while running a report in Oracle reports 6 on Oracle 8i. the help says delete it or add contents. The only problem id that in the object Navigator, when I try to delete ie, I get the above again. When I go into the layout model to delete or add text, I cant see it. Is there...

I am using reports 6.0.8.13.1 running on Oracle 8i. I have a report that prints a schedule for each account, listing dates with a value against each, then when the account changes, a total is printed. I have put in the Page break after report property so that it throws a page after each...

I have a table accts in Oracle 8i from which I want to select cust and acctno. Each customer can have more than 1 acctno. So select cust,acctno order by cust,acctno from accts returns cust acct 1 989 1 990 2 010 2 011 2 012 3 001 4 800 etc. I can product a comma delimited file from this okay...

Is there somewhere that the date/time last updated for an oracle table is held?

I have just installed Crystal 9 on my PC and have tried to print my first report. It views ok but prints garbage. I see from the threads that there is a problem transferring from 1 PC to another of the printers are different, but my default printer hasnt changed. I have no problem printing...

I have just downloaded the ODBC driver for Oracle 8i from the Oracle site and installed it on NT. I am using the Oracle client 8.1.7.0.0 and the odbc was 8.1.7.4. In the ODBC driver configuration test connection, I get the message 'SQLSTATE=lM003 Specified driver could not be loaded due to a...

I am trying to open a report using Reports version 6 on NT and I am getting REP-1070 Error while opening or saving document. I have checked the attributes on this report and it is the same as all the others which are okay. I tried Type-ing it and it reads it okay, so it seems to be something...

I am trying to open a report using Reports version 6 on NT and I am getting REP-1070 Error while opening or saving document. I have checked the attributes on this report and it is the same as all the others which are okay. I tried Type-ing it and it reads it okay, so it seems to be something...

I want to write a generic function to compare the before amendment and after amendment rows in an Audit Table created by various triggers. Can you access the columns using 1 to no of columns in the same way as you can order by 1 etc? I thought of picking up the column names from...

I want to pick up a form name to use in a loop. Is there any way to acces forms in a similar way to formfields ie using an index? ie forms(0).name = Myfirst form Thanks

When I change cancel to false in the Exit event when my date validation returns false, the cursor disappears. Is there a way I can find out where it is? Im assuming its in the Date box again or can I make the cursor visible?

I have a couple of functions that do very simple validation on text boxes. See below the code for the date check. When I call this function, and Non Valid Date value is displayed, I want the cursor to go back to the text box that called it, hence the setfocus, But it doesnt work. By the way I...

I have several forms which have tick boxes. For most of them I can translate the answer to Yes or No for printing on the Word Document that I am populating with the forms. Unfortunately thete are 2 which require me to print a tick in a box. I can find this in Symbols in Word, but cant find...

When I create a text file useing generate to file using reports, the CPU usage hits 100% and it 'sits there' for a long, long time. If I am simply creating a report, it takes 5 seconds. Has any one any ideas?