Recent content by lloydt

  1. L

    FIND LAST from 2 tables? Is it possible?

    first, scan2.empl-no = tempreporttable.scannedon ... is that a correct comparison? I don't know if it's a performance improvement or not, but try your for each like the following, it's at least easier to read and follow: for each scan2 where scan2.scannedon = tempreporttable.scannedon and...
  2. L

    How to get the Time Zone?

    Your format is Coordinated Universal Time (UTC). I'm not sure of the version of progress that you are on, if you are on 10.1b (possibly 10.1a as well) or later, there is a datetime-tz data type and related functions that work pretty good for this. Check out the timezone function in openedge...
  3. L

    Find the .W than ran this Procedure?

    not sure this gets what you are looking for, but check out PROGRAM-NAME in help
  4. L

    Message Boxes "activate" the code?

    I apologize, I didn't know the context of your situation from your previous post and was posting generic response. Without seeing the code (sounds straightforward enough) I've got a few guesses as to the cause. First, if you are compiling to .R code, I have run into similar situations where...
  5. L

    Message Boxes "activate" the code?

    I can't promise this will help your cause, but it's what I've experienced along the way. It's kind of complex for me to explain so I apologize if it's a little foggy. I've found that that kind of thing happens because there are events that either walk on each other or an event or some piece of...
  6. L

    -D limit exceeded

    Try bumping up the -D parameter to 150 or so. Also, if you are not compiling to .R code, try doing that to see if it clears it up... that's strictly a guess on my part based upon the documentation for the -D command line option (below). Regards --Lloyd From the Openedge Deployment Startup...
  7. L

    Get Data from serial port

    In a past life, I was able to use mscomm32.ocx which is a Microsoft ocx in system32. I don't know if it's related to vb6 controls or not. The only issue we ran into was being able to determine the end of the communication, basically implemented a pause for 1 second and assumed (hoped) it would...
  8. L

    OLE in Progress

    This is an oldie but a goodie http://www.oehive.org/node/467 but not sure about how it does anything with winword. I'm guessing you should be able to find some doc on the winword api, but here's some code that will open a file and then close it in winword. DEF VAR hWord AS COM-HANDLE...
  9. L

    C# question

    One thing you may try is the NotAvailable property on the AppObject. I've not tried that before nor been concerned about the connection dropping itself, admittedly bad practice, but out of my control. I'm _guessing_ that would help... there is also a issessionavailable method on the AppObject as...
  10. L

    How can I know which OCX files were used in one program?

    I don't know if this is a universal solution, but at the apps I'm looking at here, OE 10.1B, there is a procedure adm-create-controls which lists the guid for the registry and also gives the type of control, it is commented out within the procedure, all generated by appbuilder I assume. This...
  11. L

    Cannot Start AdminService

    I think we've used local admin, but domain admin may work as well.
  12. L

    Cannot Start AdminService

    We've run into that here on 91e04 and found that progress needs to be installed as the administrator user, not a user with admin rights. After doing that, it fixed that problem on 2003 and xp. I'm assuming the same holds true for oe10+. a workaround if you don't want to reinstall is to...
  13. L

    9.1d --> 9.1e

    we made the move to 91e04 about a year ago and I don't recall having to do anything to the db. I may be wrong, but I think the db conversion is usually only required for major version changes, i.e. 9 to 10. Regards
  14. L

    C# question

    I don't believe it's possible to access a .w form, the proxygen serves the purpose of exposing the Progress database and functionality as a backend and allows for setting up an n-tier/n-layer approach with the data access and potentially the business logic on that side of the fence so to speak...
  15. L

    C# question

    basically a proxygen is a means to run code as well as send and retrieve data with a progress database via appserver or webservice. FWIW I've found the appserver to be most useful, be sure to set it up as stateless though, otherwise weird things happen. Using prodatasets makes this really cool...
Top