Search results for query: *

Is there an Oracle command to retreive the code used to create a view ? I am using Oracle 9i. Thanks very much.

I am working with Crystal 8 and an ODBC to Oracle I have table of test results and I need to pull back only the records that have more than one entry in table(for their ID) and then of those..I need to only select the 2 most current records based on testdate field. Is there a way to use...

I am running Crystal 8 and using an ODBC to an Oracle DB. I need to group by the a datetime field where the most recent date minus the next most recent date falls within categories of Less than 2 years, 2-4 years, 4-6 years etc. The same id can have multiple entries so how do I,after sorting by...

I am using Crystal 8 and Delphi 7 and I have 2 parameter related questions: 1) Is there a way to rename a parameter? Even when I remove it from the report first,it will not allow me to rename it. 2) Can the ok button be disabled until all the parameter choices have been entered since if you hit...

I am using Crystal 8 through Delphi 7 with an oracle ODBC. When the user selects cancel rather then choosing a parameter..the report runs anyway. How can I prevent this?Thanks

I am using Crystal 8 run through Delphi 7. I want to group the report by the description name that I typed in with the parameter list. Is this possible?

When running my Barcode exe, I get "error accessing the OLE Registry" Any ideas on where my problem might be?

I am running crystal 8 with an odbc to an oracle database. When I write the report I set a parameter to the location code field in the Location table.When the client runs the report they get my default location codes. If I don't arrow over the location codes in the parameter setup ..then the...

I am using crystal 8 and am unfamiliar with 'add command' that I am reading about in other posts.. Can someone give me a brief overview of how it works.

I am using Crystal 8 and ODBC connections to Oracle. My subreport hits a totally different database and I can't seem to get it to work. Any ideas?....... thanks

is there a way to be able to see the Sql statement when using 2 databases?

I need to use an id that is a string as a link to a subreport field that is a formula combining a numeric id with a manufacturer code. I use cstr(numeric id) + manufacturer code so that I can concatenate the 2 fields but then it formats the numeric id as a number with commmas and decimal...

SELECT METERREADINGS."READINGTYPE", METERREADINGS."KWHREAD", METERREADINGS."KWREAD", METERREADINGS."KVARHREAD", METERREADINGS."KVARREAD", TRANSACTIONS."TRANSACTIONTYPE", TRANSACTIONS."DEVICEID", TRANSACTIONS."LOGDATE", TRANSACTIONS."LOGBY", TRANSACTIONS."RESERVED1"...

UNABLE TO EXTEND TEMP SEGMENT BY 256 IN TABLESPACE TEMP." I am running Crystal 8 with an ODBC to an oracle database. How do I expand the temp space?

I am using Crystal 8 with an Oracle ODBC. I need to search for meters in need of an inspection based on a numeric interval of how often(in years)an inspection is required. My thought was to use a formula that pulls the meters with inspection dates that are < the currentdate - the interval but...