Search results for query: *

Is it possible the "_" is a reserved character on your system? If so you may have to enclose the name in qoutes. VTJ

Dear Sync, Thanks for the response. I'll let you know how I make out. VTJ

Hi, I've been asked to enable a direct connection to Impromptu from within a java created program. The users want to be able to open Impromptu without reentering their logon information. Does anyone know of any links to documentation on this subject. Thanks, VTJ

The execption join may be database specific which is why I offered the second example. The term is exception join on the AS/400. VTJ

Try an exception join or left outer join. Select a.key1 from tbl_1 a exception join tbl_2 b on a.key1 = b.key1 or Select a.key1 from tbl_1 a left outer join tbl_2 b on a.key1 = b.key1 VTJ

I had the same issue with DB2. I was told to add the line: NOSCAN=0 in each of the Schema entries in the DB2CLI.INI file. The Cognos case number was 3094378 I hope this helps VTJ

While you can't rename the column in the database, you can rename the field in the report or a new file by using a SELECT field1 AS newfieldname. VTJ

Try removing the table qualifier ("A") from your filename. The system may think cuno is a variable as opposed to the column name (A.cuno). VTJ

You can also use a subselect in your where clause. where childid in (select a.childid from maintable a where a.therapist = therapistid) VTJ

Thanks for the help. I'll try it and let you know. You may be right about the mapi. Thanks VTJ

Sorry if I seem a bit dense. This is my original script. Function Email(Message as String) Dim objSession As Object Dim objMessage As Object Dim objRecipient As Object Dim sProfile As String 'You can specify any name you desire sProfile = "Company Exchange&quot...

I should have realized that you would want it to be dymanic. An alternative is use the Catalog description object. Set this description to the name of the catalog and insert that object into the report. You can change the description by clicking on the catalog menu item and select the...

Thanks for your reply. Unforunately I've not been able to get it to work. When I past it into the script and try to compile I get an error objOutlookEMail.cc is not a valid object. I'm trying different combinations of your solution and will let you know if anything changes. I'm using Outlook...

This is a bit convoluted but it works. Insert the catalog name then select it and copy it. Open Notepad and paste in the name. Delete what you don't want then copy that. Insert a text frame into the header and paste in the string you want to see. Delete the catalog name from the header...

I've created an email script to email pdfs to multiple users. I would like to add a cc to those emails. Does anyone know how to do this? We use Outlook as our corporate email system. Thanks, Vtj VTJ

Try this SELECT CHS1.CONTRACT_ID, CSH1.SEQNO, CSH1.REQUEST_DATE FROM CON_STATUS_HISTORY CHS1 WHERE CHS1.SEQNO = (SELECT MAX(CHS2.SEQNO) FROM CON_STATUS_HISTORY CHS2 WHERE CHS1.CONTRACT_ID CHS2.CONTRACT_ID GROUP BY CHS2.CONTRACT_ID)...

Is the field NULL capable? If the field allows NULLS you could do a simple update SQL and set the value to NULL based on your select criteria. If you have a "look up" table that contains the list of valid entries add a "blank" value to that table and you shouldn't have a...

Have you looked at the attributes of the files. If they are marked Read Only you will have to uncheck that box before you try and replace them. Make sure you when you run windows explorer that you check view all files. VTJ

Would you clarify what you are trying to insert. Must it be a NULL or are you trying to "blank" out the current value? Thanks VTJ

Is this related to the thread you posted on 7/13? I'm not familiar with Oracle but ANSI SQL has a "between" predicate that should work for you. Select Fld1, Fld2 From Tbl1 Where somedate between date1 and date2 somedate corresponds to the date in the file and date1, date2...