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 TouchToneTommy 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: jonbrown
  • Content: Threads
  • Order by date
  1. jonbrown

    Multiple Instances

    Can anyone tell me if it is possible to run multiple instances of websphere on the same box?
  2. jonbrown

    Query/Procedure to recompile all views and triggers

    I need to construct a procedure to recompile all views and triggers in an oracle 8i database. I plan to use a cursor to loop through the USER_VIEWS table, get the view_name and substitute it in the following statement: ALTER VIEW :viewname COMPILE The problem is that the procedure compilation...
  3. jonbrown

    Declare a Cursor with dynamic from table name

    I need to delare a cursor within a stored procedure, but do not know the name of some of the tables to be used in the query until run time. I can get the table names into variables and can build the SQL Select statement into a string as required, however I cannot find out how to declare the...
  4. jonbrown

    MS Excel 2000 Changes Menu Macro on Save As

    I am trying to create a macro in MS Excel 2000 that saves a spreadsheet as HTML then reopens the original file. I have, I beleive managed to get the required functionality working OK. The problem is that having attached the macro to a custom menu, once the macro has been run, the attached macro...
  5. jonbrown

    Varchar(2000) Truncated at around 500 Characters

    I am creating a stored procedure which selects data from various tables and builds up 5 strings which will be used as the contents of an email. The output strings are declared as varchar(2000). The problem appears when the number of characters gets to around 500 - Everything after that seems...
  6. jonbrown

    Selection formula Problem

    I am reporting against a database that stores date times as the number of seconds since 1/1/1970. I can create a formula to convert a datetime in crystal into seconds since that date - no problem. However, when I use the conversion formula in the selection formula to narrow down the selection...
  7. jonbrown

    Schedule an export to .pdf format

    How would I go about scheduling a report to run, export to .pdf and save the .pdf file in a specified directory. Can this type of functionality be acheived in Crystal Enterprise. Can you recommend any good guides/books about this area of Crystal (SDK I presume)

Part and Inventory Search

Back
Top