Oracle SQL problems

[pelajhia]

I have worked out a few queries in toad which I would like to use in Crystal. I am using CR 9 and thought I should be able to pretty much copy and paste that sort of thing right into a command, but I am having problems with more complicated commands. Items like 'decode' or 'sysdate' don't seem acceptable - hitting 'ok' when trying to finish entering the command just makes the app hang forever.
Is there a guide somewhere to what is and is not acceptable within a CR9 command for ORACLE 8i?

I have had some luck with entering small parts of a larger block of code and slowly building up to the final, larger sql statement, with no discernable differences b/w what I originally had in toad and what I have in CR, it's hard to tell what I'm doing incorrectly. I do have to switch out certain parameters b/w the two apps.

Any help is greatly appreciated!

 

[synapsevampire]

My approach is to use Views or SP's. One of the big advantages to using Views is that you can reuse them.

I'm not aware of unacceptable commands using Oracle, and I'm just getting back into Oracle with CR. I know that I can use a CASE in SQL Server as a SQL Expression in CR 8.5, so I'd be very surprised if CR 9 has a problem with decode in CR 9 (and I've used decode in CR 8.5 also).

Perhaps the query is taking a long time to return the rows? Try adding in an additional filter in the where clause to minimize the rows and see if that helps.

-k

 

[pelajhia]

Thanks for the suggestion; I'll give it a try asap.

 

[pelajhia]

Yes, the added filter allowed me to at least add the basic statement - it still took a long time, but it did work. Thanks!