Search results

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

    C# question

    One other solution that may work for you if you are on progress 10 is to set up a proxygen and call a progress program on the back end via that, all it requires is an appserver. I use that approach in a couple applications and it works great. Regards --Lloyd
  17. L

    C# question

    Hey Tom, If I understand you correctly, you want to capture a trigger event in the progress session based on your .net com object. Based on that, it's not possible with today's progress. My understanding is that in order to do that, the com object needs to have a certain type of signature, and...
  18. L

    Sequence Dump and Load

    Forgot to mention. Progress 91e04 - dump Openedge 101b01 - load
  19. L

    Sequence Dump and Load

    Thanks for the point in the right direction, I was able to hack something together, here it is. On a sidenote, need to have the $DLC/src/prodict.pl in the propath for this to work. dumpseq.p ---------- def input parameter ipDbName as char no-undo. def input parameter ipOutFile as char...
  20. L

    Sequence Dump and Load

    Is anyone aware of a way to programatically dump and load sequence values? I've attempted dumping and loading the _sequence table but there's apparently some magic that takes place in the admin tool that I'm missing. :tear: Thanks!
Top