Recent content by kaymc

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.

Thanks so much Dima! You got me looking in the right direction and after a bit of fiddling I got my refcursor working with crystal. You, sir, are a lifesaver.

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

Oh well. Thanks.

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

Thanks guys. Very helpful advice.

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

Yessir, 1899-12-30 seems to be the magical number. Our system inserts a call duration value (in hours:minutes) into a datetime field. When you look at this field through EM you get 00:01:32 and the like, without any date component. Recently I've been trying to insert some data from our old...

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

Bigfoot, Don't use the .mdb as the "look for" file. Uploaded a one or two byte file immediately after your main file, and begin processing the other only after the second file appears.

You can, and here's how: Go into your enterprise manager, go down to Data Transformation Services / Local Packages. Right click to create a new package. When your new package opens up, go to the Task Menu and select EXECUTE PROCESS TASK. Click in the elipse next to the Win32 process task and...

'--------------------------------------------------------------------------------------------------------- 'VB Script to run a DTS job only when a file exists. This puppy will sit waiting in the background 'quite happily. I hacked it together from some pre-existing code pretty quickly, so it...