Search results

  1. D.Cook

    Stream - is open?

    Separate variable it is...
  2. D.Cook

    Stream - is open?

    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...
  3. D.Cook

    Can you save an Excel spreadsheet opened within Progress as a .csv?

    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...
  4. D.Cook

    Right-click on browse, context menu

    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...
  5. D.Cook

    Color coding in 10.1c

    You may need to be a bit more specific about what you want.
  6. D.Cook

    Preprocessor IF THEN ELSE

    Something we've always done is just quote the values, like this: &IF "{&FIELD}" = "4" &THEN &ENDIF
  7. D.Cook

    text in red color

    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.
  8. D.Cook

    CAN-FIND(FIRST ...) Surprise

    Thanks a lot for your response Andrew, now everything makes sense!
  9. D.Cook

    Bulk Update is better in Progress 4GL

    If it's speed you're concerned about, why not test each method with the same data, and see which is quicker?
  10. D.Cook

    Can't let the user enter a bad value in a browse

    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...
  11. D.Cook

    CAN-FIND(FIRST ...) Surprise

    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...
  12. D.Cook

    Connecting a 10.1C client to 10.1A database

    Thanks Tom I've also been directed to this article on the Knowledge Centre: ID: P132...
  13. D.Cook

    Insert Table into Word Doc

    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...
  14. D.Cook

    Connecting a 10.1C client to 10.1A database

    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...
  15. D.Cook

    Passing blank numbered parameters to an include file

    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...
  16. D.Cook

    Passing blank numbered parameters to an include file

    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...
  17. D.Cook

    Passing blank numbered parameters to an include file

    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 ""...
  18. D.Cook

    Best way to loop through Excel

    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...
  19. D.Cook

    Output to Terminal in Batch Mode UNIX

    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...
  20. D.Cook

    Excel - Wrap within Cell

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