Search results for query: *

Is it possible to convert a CLOB datatype to VARCHAR2 in Oracle 8i? I need to do this because I am referencing a field (currently a CLOB) in a crystal report. Crystal cannot read the CLOB in its native format, as far as I am aware it can only read VARCHAR2 fields. Please can anyone help me...

Is there any way to read environmental variables in Crystal? I need to display the user's Novell logon name, Environ$("Name"), on a report. It seems like something that should be pretty simple. For the record, I'm using version 8.5.

Hi, I'm fairly new to Oracle, although I've used SQL Server for years. I'm currently producing a horrible little Crystal report where I'll need to pass parameters to a sql function and have it return the data I need -- Not just a value or a row but 10 or 12 rows. Now with SQL server it was...

I guess I already know the answer to this before I ask, it's just that I keep bumping up against the problem. Why, oh why, couldn't they have implimented a distinct count function in vba? How hard could it have been, really? I mean Crystal has it! Yes, I know I should handle it in my query...

Two tables, one contains a list of questions to ask the user about a selected client, the other table contains the answers assigned to that client. One record per question answered, if the question is skipped, there should be no record in the answer table for that question. It should go...

Never really used automatic cross-tabs until recently. I got the idea somewhere that they were useless but am quickly discovering how quick and useful they can be. Unfortunately I've just run into a brick wall of sorts. My cross tab report breaks down a distinctcount of Order numbers by Order...

I'm writing a report where I need to be able to count the number of unique instances of two fields broken down by month across a year. I have my data coming from a SQL Server 2000 view into a Crystal 8 report. My report will hopefully look something like this... Jan Feb...

I have an INSERT INTO SELECT query (which should insert around 80000 records), where I need to ensure new unique values are assigned to one of my key fields. No, it's not an auto-increment field. No, I don't plan on changing that fact. If it where an update I could declare a variable and use...

I have one pesky ickle trigger which I have to delete before I run a few innoecent queries in a DTS job. Up till now, I have simply recreated the trigger in my script after the queries have been processed. Now the problem is that this trigger gets changed from time to time and I have to change...

How can I force DTS to re-generate transformations upon execution of a DTS job? I know lots of folks have had similar questions, but I've yet to see an answer which is directly applicable to my situation, so I'm going to ask it again. Some Background: We're in the process of upgrading from a...