Recent content by it@flude.co.uk

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

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

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

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

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

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

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

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

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.

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.

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

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"...

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

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

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