Hitting up the ABL reference i was surprised to find that the Stream object does not have an IS-OPEN attribute. How am I supposed to know if it is available (in this case) for writing? Of course I could keep a separate variable for the open status and manually maintain it, but that's not a clean...
I find the Excel VBA Reference help file installed with Excel to be pretty handy. It lists all the functions you can access via the COM interface. Obviously the format is in VBA, but you can translate to ABL quite easily.
It's usually located in a location like:
C:\Program Files\Microsoft...
If you've noticed this before, the code below might be of interest to you. When you right-click on a browse row that is not selected, it is not selected before displaying the context menu. This isn't what I would normally expect. After all, you would expect a context menu to have the correct...
Something like this should do it.
ON ROW-DISPLAY OF BROWSE <browsename>
DO:
IF customer.active = no THEN
customer.name:FGCOLOR IN BROWSE <browsename> = 4.
END.
To view all colours in the in colour table, from the Procedure Editor click Tools>PRO*Tools then the first icon on the left.
Great point Tom. Sometimes I feel sorry for users (Usually I just feel superior to them).
In the case that you have a legitimate reason for preventing a user from leaving a browse cell, try something like below. But always make sure you do not trap your user in this cell! The last thing you...
Having read the documentation and a few posts here, I'm still a little confused about the purpose of the FIRST and LAST keywords.
I'm especially confused why these keywords are allowed in a CAN-FIND statement, as they seem completely irrelevant.
It's for this reason I coded some CAN-FIND...
I'm pretty sure the named constants will not be evaluated -- you'll need to pass the actual integer value. To find out the integer values, probably just use the following VBAscript or similar:
MsgBox(wdWord9TableBehavior & " " & wdAutoFitFixed)
Then just substitute the constant name with the...
I've just tried connecting a 10.1C client to a 10.1A database and it appears to work fine.
However I was hoping I could find some definite info about backwards compatibility and if Progress will support it. Is this information available? I'm also curious about using a 10.2A client on a 10.1A...
Actually the first parameter is used as part of a variable name in the include file, like this:
def var var{1}name.So I need the first parameter value to be empty, resulting in "def var varname.", not "def var var name." which will cause an error.
Obviously it wasn't the best design in the...
Thanks for the responses.
Single quotes are (strangely) not counted as quotes, so the result is:
|'|'|And a space between double-quotes is in most cases good enough, but unfortunately I need zero spaces in this case.
| |param2|This is the result I'm looking for, but I think I'm going to have to...
Is it possible?
For example I have an include file with two parameters. The first parameter I wish to leave blank, but I want to pass a value for the second parameter.
The best idea I had was an empty pair of double-quotes. But it becomes one set of double-quotes.
{include.i ""...
What I've done in the past is have a requirement that the first column must always contain data. But this could be a problem if you are expecting blank rows in between data.
The most important thing is to define the exact format and rules for the spreadsheet. After that you just write the code...
Thanks for the suggestion, but I found a simpler way! All I did was run the 'echo' command from within Progress and it seems to work well. And if output is redirected to file it works as expected.
So my platform independent solution is:
if opsys eq "UNIX" and session:batch then
unix...
I have used "~n" before with success in creating an in-cell line break. I don't think I had to set wrapping for the cell or anything. It worked on both Excel 03 and 07.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.