Search results for query: *

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

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

If anyone is interested, I solved this myself by creating the following functionality: Sub Save() Module1.My_Save End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) For Each bar In Application.CommandBars Set cb = bar If cb.Name = "My_Menu" Then...

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

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

Problem Solved - It was purely a setting on Query Analyser only allowing 256 Chars per column. Thanks for your help and sugestions. Jon :-)

Here is the SP code - Note if I use SELECT to output the results the results are truncated, If I use print, they display correctly - Is there an output buffer setting that could be changed?? CREATE PROCEDURE SMI_ChangeSelect @id varchar(20) AS declare @detailstring varchar(2000) declare...

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

Thanks for that. I have done it a similar way in the past by doing the record selection in a stored procedure and running the report against the procedure, however, we have a customer who won't let us create the procedures!! Jon

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

Tick the Suppress check box in the format section expert, and enter the following in the formula: IF 'NOTE ID' = 5 THEN FALSE ELSE TRUE this will suppress the row unless the ID = 5

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)