Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: kaymc
  • Order by date
  1. kaymc

    Converting a CLOB datatype to VARCHAR2

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

    Reading Environmental Variables

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

    Help with Oracle Functions for a SQL Server dummy.

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

    Help with Oracle Functions for a SQL Server dummy.

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

    DISTINCT COUNT in a report

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

    Catching an updates on a combobox bound to non-updatable recordset

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

    PercentOfDistinctCount in Cross-tab (auto)

    Oh well. Thanks.
  8. kaymc

    PercentOfDistinctCount in Cross-tab (auto)

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

    Icky Manual Crosstab Report

    Thanks guys. Very helpful advice.
  10. kaymc

    Icky Manual Crosstab Report

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

    Insert Time in SQL (ONLY TIME)

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

    Inserting records with an incrementing value

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

    How to run a DTS when I want to?

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

    How do you use DTS to run a .bat file daily?

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

    How to run a DTS when I want to?

    '--------------------------------------------------------------------------------------------------------- '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...
  16. kaymc

    How can I copy a trigger?

    I should have posted this earlier, but THANK YOU so much for that procedure. It worked like a charm, and thanks to it being so general in nature, I have already found other uses for it. Thanks!
  17. kaymc

    How can I copy a trigger?

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

    Autogenerating DTS transformations

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

Part and Inventory Search

Back
Top