Recent content by warba

What emulation are you running on your NetTerm client ? Some older emulations are not intelligent in the way they redraw the screen. Also, what speed is your NetTerm client connecting to the host? Is it local LAN, or dialup?

We use the Progress Dataserver to connect to a MS/SQL database from a Progress 4GL app. I believe using the ODBC Dataserver allows you to do the same thing with any supported ODBC source such as MS/Access.

You may want to try this Toronto company that specialized in Progress placements. http://www.cssint.com/ I don't have personal experience with them so can't vouch for how successful they are, but it is a good place to start for a Canadian Progress position.

There are maybe 2 issues. 1. When running programs, your PROPATH and home directory are going to be searched, and the first found program matching your program name will be run. It is important to control where you put software (.p) and compiled programs (.r); also control your PROPATH...

Then we have proven that your system does return the correct data for the string formatting. I would maybe suggest that when you "run" dtconv.p you are maybe running a different version than you think ? Maybe you could prove you are running the correct version by modifying dtconv.p so the...

Yes, I get 200209009. If you simply execute the following: message string(day(today),"99") view-as alert-box. Do you get 05 ? If you try: message string(day(today),"999") view-as alert-box. Do you get 005 ?

That is odd. If you change your "display" statement to read: message dt2 view-as alert-box. Do you then see 200209009 ?

I think if you want to convert a date format variable into a character variable in the format YYYYMMDD, you may use this syntax: dt1 = string(year(dt),"9999") + string(month(dt),"99") + string(day(dt),"99"). The format mask of "99" will always pad zeros so "3" will be "03"...

Possibly; 1) use online backups and don't shut anything down 2) check status' of each previous step before continuing (or just pause for a minute or two between each step of db startup/adminserver/nameserver/broker startup).

Change date.p to read: /*date.p */ define var dt as date initial "02/11/22". define var dt1 as character. run dtconv.p ( input dt, output dt1). display dt. In the calling program, dt and dt1 are not input or output parameters, they are only variables. It is in the called...

Thank you Murray. That works perfectly (_myconnection._myconn-userid). Warren.

Does anyone know if there is a way to determine the user number, shown in a db .lg file, from within Progress 4GL: 22:47:49 Usr 40: Login by batch on batch. (452) 22:48:10 Usr 38: Logout by robob on /dev/pts/1. (453) 22:48:20 Usr 40: Logout by batch on batch. (453) 22:50:23 Usr...

If you are accessing a ChUI application using a PC, you are maybe using telnet ?? If so, many telnet clients allow you to send special escape sequences that will let you run a command on the PC. You could use this to copy the file to your PC. We do this type of excel import from a UNIX...

You should be able to use: proutil dbname -C dbanalys and look at Record block summary and Index block summary to get an idea of the space used for records and indices.

We've been on Progress and AIX ChUI for almost 10 years, and are on 9.1C, plus we have a Webspeed ecommerce site. ChUI has been perfect for our applications thus far, but some are now requiring some GUI. We read about ADM and Dynamics, but some of the Progress community seems cold on these...