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 not sure if I missed something or most likely didn't explain it too well...but I don't see how this compares the datetime field from 2 different rows (the most recent and the second most recent) ?

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 have had 2 clients that I am writing reports for request that when there are multiple parameters, that they cannot select the ok button until a selection has been made for each parameter and also they don't like that when you select cancel from the parameter screen that the report runs anyway.

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

Thanks. My dilemna is that I am grouping on an inventorycode which consists of a locationcode(quarter and year). for example 50(Q106). The customer gets to the inventory code by matching 3 parameter (the location code, the quarter and the last 2 digits of the year )The customer wants me to...

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...

Sorry, I wasn't sure how deep you wanted me to explain the data. There are many different transaction types. I am using only 4 on this report. The reserved fields are populated with different data depending on what the transaction type is. I need all 4 transaction types on the report. I only...

I am still only getting the transaction types(set and rmv)that have a service id in the reserved1 field. There is a constraint that requires all of the premise numbers in the service table to match up with the premise table. Is there something else that I am just not seeing?

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 appreciate all the help! I ended up adding the interval(number of years before an inspection is due) to the last inspection date if the newly created date falls within the user's date range then the report will tally the number of meters that are due to be inspected. IF (...