Recent content by jakea

I've managed to "borrow" bits of code from various sources, and have finally got this working fairly well (in SyteLine, but should work with any Progress application). Sorry, I can't remember where from, but thanks if you recognise any of your finely-crafted code! If anyone wants a copy, get...

Erm... Why is the code in the original file in a Procedure? If you just remove the "Procedure..." and "End procedure" lines, you can just call the program, can't you? Or if you insist it is a procedure, add a line at the top of the file: RUN CreateVersion... and then have RUN...

Does anyone have any sample code for interacting with QAS's Quick Address API to validate addresses and postcodes? It would be great if I could avoid re-inventing this particular wheel. Thanks in advance, Jake Arnott.

That will work (it's the same as adding the subroutine from my initial post), but how do you do this from Progress? How do you specify the template you want to use when creating a spreadsheet with the com object? We use Citrix, so there's a slight problem of knowing where the template would...

Casper, thanks for getting back to me, but your code is pretty much what I've used to turn this functionality on when the spreadsheet is created and opened. The problem is that although it works when the sheet is first opened, if you re-open a saved version, auto-filter no longer works. If...

I've used EnableAutoFilter in a spreadsheet produced from Progress 8, using the excel.application COM object, in order to allow users to filter columns in a spreadsheet with some protected columns. However, I have run into the problem that it needs to be re-applied every time the spreadsheet is...

We are trying to connect RF barcode scanners to a V8.3b database (Syteline) running under NT. At the moment we conect via a UNIX box using VT100 emulation on the scanners, and all works fine with code specially written for the 16*22 screens. We want to get rid of the UNIX box and telnet...