Search results

  1. I

    unix quest

    No probs, glad to be able to help. I have found that the script will delete files with unusual characters in the filename where rm on its own just doesn't work. For some reason, our system had some files that had very long binary-style filenames that had been left by a previous programmer...
  2. I

    New to MFG/PRO

    I'm about to take up a new position which involves MFG/PRO administration and programming extra reports, linking to a separate Progress-based system and various other odds and ends. However, I have never used MFG/PRO before. :) Is there anything I should know about how MFG/PRO does things...
  3. I

    unix quest

    Try a quick shell script, or type it into the command shell - BUT BE CAREFUL: for i in `ls` do echo -n OK to Delete $i read y if [ "$y" = "y" ] -o [ "$y" = "Y" ] then rm $i fi done
  4. I

    How Can I Auto Load an Incremental .df Schema Change File

    It's in prodict/dump/_lodsddl.p - you could copy that off to another program and amend the reference (ASSIGN dbload-e = LDBNAME("DICTDB") + .e".) but then you'd have to copy all the include files as well. Or, a simpler way might be to do an os-copy in the calling program to copy the .e file...
  5. I

    Dynamic COLUMN-LABEL values

    I think he was after a report rather than a browse. The following method works in V8.3b and I can't see why it shouldn't work for V9 or OE10. I don't know if it works in V7, but V8 is ancient enough. The trick with doing this in a report is to use the no-underline option on the frame. You...
  6. I

    EnableAutoFilter

    I normally use a little cheat. Copy the template excel file to the path/name you want the new worksheet to be, then open the new worksheet, rather than creating a new one. By the way, it isn't a Template in the same way that Word has Templates, this is just a normal Excel Worksheet that you...
  7. I

    Starting a Dial-Up Connection

    Has anyone found an easy way to start a Dial-Up Internet Connection from Progress? I need to password protect some Internet Connection Icons to stop people messing at night ..... The only way I've found to do it is a bit messy: 1. Create a Shortcut to Network Connections from Control Panel...
  8. I

    EnableAutoFilter

    That's what I tend to do with this kind of thing. Put it into a macro and make the macro auto-execute when the sheet is opened. So, set up a blank worksheet, put the macro into the sheet and make this a template. When you need a worksheet with this particular property, copy the template to a...
  9. I

    Validating Field Input During UPDATE

    The validate command seems to fire at the end of the update. Try putting a trigger like this in your code: on leave of edate1 in frame a do: if date(edate1:screen-value) <= date(edate:screen-value) then do: message "Invalid Date" view-as alert-box. return no-apply. end. end.
  10. I

    Field validation expression.

    When we use the dictionary validation, we refer to an include file. That way, we can change it while people are logged in and using the system. But, generally, we rarely use it for the reasons above.
  11. I

    Lookup Vs. Blank Parameter

    If you use lookup or OR then it blows your index. There are several ways of doing this. Have you tried taking the logic out of the loop? Something like: FOR EACH op_hist NO-LOCK WHERE op_site >= loc AND op_site <= loc1 AND...
  12. I

    Dynamic COLUMN-LABEL values

    That won't handle Column-labels properly, though. :label normally affects side-labels, although it will work if your column-labels are single line. So, it will work for def var myword as char column-label "My Word" no-undo. But not for def var myword as char column-label "My!Word"...
  13. I

    Dynamic COLUMN-LABEL values

    I've never managed to do this. What I've had to do as a work around for fairly dynamic reports is to use a large array of characters (for convenience, up to 50 fields in the report, but could be more), dynamically size them depending on the data they hold, then allocate a couple of header...
  14. I

    Getting around the maximum frame width

    I've run into the same problem when producing very wide reports. Since I can't meaningfully print 300 character wide reports, I normally assume that such reports are for importing to another application, such as Excel, and treat them as such. Generally, I use PUT rather than EXPORT when...
  15. I

    Licensing - is Progress licence "Application specific"?

    We had a similar problem when upgrading from V8 to V9 for our Payroll package. In the end, we upgraded our V8 licences for our in-house application directly from Progress and then used those licences for the Payroll application as well. As far as Progress were concerned, as long as we had...
  16. I

    MS Excel Version

    Try: message excelAppl:application:version view-as alert-box.
  17. I

    Making GUI fields act like character fields

    If you use the UPDATE command with session:data-entry-return = yes you should get the result you want. Alternatively, use a trigger on the last field: on return of last_field in frame whatever do: assign last_field. apply "go" to last_field in frame whatever. end.
  18. I

    Frame Parent Child Attributes

    That seems to work, I've got two frames defined f1 and f2, I put your code into a procedure and ran it. It gave me both frames. You might be hitting the leave main command and leaving early. To check on frames, try this before main: DO WHILE VALID-HANDLE (h): MESSAGE "h" h h:name h:TYPE...
  19. I

    _osprint query

    What we tend to do is to store printers in a Progress Table. Users choose a printer from the table and we use the corresponding devicepath in printfile.p. Alternatively, you could try to extract the Windows printers into a temp-table and browse that to select a printer. We use prntlist.p to...
  20. I

    Frame Parent Child Attributes

    Just check the names/types/handles of the parents. That way, you can see if they both belong to the same widget or if they belong to something else. If you don't view the frames first, they don't have parents. Try the following code, then comment out the view frame statements and watch it...
Top