Search results

I am having a problem interfaced with Excel. I'm trying to open a workbook, copy the first worksheet of the workbook and paste that worksheet into a new empty workbook. Unfortunately, I am getting two new workbooks. DEFINE VARIABLE gchExcelApp AS COM-HANDLE NO-UNDO. DEFINE VARIABLE...

I am trying to read through mail for a specific Lotus Notes user and to detach all attachments that I find. So far I have the following: DEFINE VARIABLE chSession AS COM-HANDLE NO-UNDO. DEFINE VARIABLE chDatabase AS COM-HANDLE NO-UNDO. DEFINE VARIABLE chView AS COM-HANDLE NO-UNDO. DEFINE...

The output in question is going to another stream?

I believe that you are looking for ENTRY. DO i = 1 TO combo:NUM-ITEMS: MESSAGE combo:ENTRY(i) VIEW-AS ALERT-BOX. END. HTH Anne

If I run the logic without the endTransactionValidate procedure I do not receive the duplicate record. This only started happening since I added the logic to check the Effective Date. As far as the incrementing of the Revision Number goes, this happens in the preTransactionValidate procedure...

Thanks for the pointer. Here's another attempt at the code then: FOR EACH RowObjUpd WHERE RowObjUpd.RowMod NE "D":U AND LOOKUP("EffectiveDate":U,RowObjUpd.ChangedFields) NE 0 NO-LOCK: FIND FIRST...

And in a completely unrelated topic -- Why do messages at ProgressTalk get stripped on leading spaces? I went through the bother of formatting my code sample to be readable and then the message stripped out all of the spacing. Anne

I was pretty much thinking that my logic should be in the EndTransactionValidate procedure. That being said, I am getting some unexpected results. When I add a record that causes a second record to be updated, both of these things are happening but a second record is also being created. (e.g...

It does not matter any longer for this issue since it is no longer a problem, but is anyone out there? I noticed that there haven't been any answers for the questions in the ADM2 folders in the recent past. Has everyone lost interest in ADM2 or doesn't anyone have the answers? (Both valid...

Progress version 9.1C I have a question about how to best handle something using ADM2. What I have is a SmartWindow with a SDO, SDV and SDB on it. When I save a record, I need to update other records from the same table. Should I do a submitRow in one of the *TransactionValidate procedures...

Progress 9.1c I'm having an odd problem with SmartSelects. I have a SmartViewer in which I have two SmartSelects. The first SmartSelect is to a model table and the second is to a make table. The two SmartDataObjects that back these SmartSelects are linked by the model number. This seems to...

Hope everyone's Christmas dreams come true! (And as a Christmas present to myself, I hope I hit the Powerball jackpot!) Ho! Ho! Ho! Anne.

I'm using 9.1C on Windows 2000 and I stopped at the following points: 9 a - z # a a And I have no idea if this behavior can be changed. Anne.

I tried the following code in 9.1C and it seemed to work fine. DEFINE VARIABLE a AS CHARACTER. DEFINE VARIABLE b AS CHARACTER. DEFINE VARIABLE c AS CHARACTER. FORM a b WITH FRAME one. FORM c WITH FRAME two. UPDATE a b VALIDATE(b NE "":U,"You have to fill in this field!")...

Is something like this what you are trying to do? DEFINE VARIABLE SELECT-1 AS CHARACTER VIEW-AS SELECTION-LIST SINGLE LIST-ITEMS "Option 1","Option 2","Option 3","Option 4","Option 5" SIZE 11 BY 3.6 NO-UNDO. DEFINE VARIABLE SELECT-2 AS CHARACTER VIEW-AS...

The following code is using a variable of course, but it is a simple program that you can run to see what I mean. DEFINE VARIABLE c AS CHARACTER FORMAT 'x(300)' LABEL "Debug Information". UPDATE c VIEW-AS EDITOR SIZE 78 BY 4. OUTPUT TO PRINTER. DISPLAY c VIEW-AS EDITOR SIZE 78 BY 4...

I'm a little confused. Why don't you just print it as an editor? Then the data will look just like the editor on the screen. Anne.

I am working on a system that has a report that needs to be exported from WebSpeed to Excel. To accomplish this the following commands are used: Output-Http-Header("Content-disposition","Attachment~; filename=MyReport.xls"). RUN OutputContentType in...

Has anyone out there ever heard of a solution for getting tones to a machine running a Telnet session. I have an application where the users want different tones at different points in the program, but don't know how I can do this since the terminals are running emulation. Any ideas? Anne.

Thank you for your insight. I like your reasoning for having the numeric index. That may have had more to do with the decision than the query speed. Sometimes it is hard to look at an undocumented system and try to figure out the reasoning behind the structure. Anne.