NeilIV

When we used the control, we were able to add an attachment using the following:

$Filename = POLICY + CDATE(ENTERED)
+ ENTERED_TIME + '0200.pdf'

$Filepath = 'S:\XXYShare\DEV\SLON\' + $Filename

#T = ProMail.AddAttachment(PR)


"PR" INTERFACE MAPPING WITH THE FOLLOWING VARIABLES:

sFileLogicalName = $Filename

sFilePath = $FilePath


Not sure why it would not attach for you. I notice it(PROIV) is sometimes very touchy as to where in a function this is called. Worked for us pretty good.

As a side note,

We are running 5.6 and I still have problems with a SQL statement only returning 1 row on an Oracle table with a alpha sequence. It is pretty madening. I would shy away from alpha-sequences as keys if you are using oracle. We also have used Oracle sequences and find them pretty nice.


NeilIV

Yes Tom! Yes we are.

Have you tried using the client.execute code?

I have used it for Adobe stuff before, a sample would be:

#A = CLIENT.EXECUTE('Acrord32.exe','','','SW_SHOWMINNOACTIVE')

The PROiv properties pdf has some additional information on using this code that is, believe it or not, pretty helpful.

While I am filling my grid, when I get to a row that meets my test( for an new color) I can change individual cells to the color I want by doing the following:


First I set the value of the color to a variable such as:

$VAL = '178,34,34'

Then, in my case I only want certain cells red, I do the following:

FOR #I = 6 TO 10
#CELLCOL = #I
GRID.setForeColor(SFC)
ENDFOR

The map contains the value for the Row, Cell, and color like: #CELLROW, #CELLCOL, $VAL.