Search results

  1. K

    Case statement

    Ignore my post. I've just realised I don't understand a word of the OP.
  2. K

    Case statement

    for each prospect where what?
  3. K

    Easy

    It is. You can also right-click on a keyword and select Keyword Help. I find the additional shortcut useful because I occasionally want access to the help when I am not in the development environment, or when I have a program running from the appbuilder, and I don't want to close it down to...
  4. K

    Easy

    Useful advice. It may seem blindingly obvious to some, but it took me a long time to think of it. I also have a folder on my desktop with the shortcut you have just described, in addition to shortcuts to the main menus of the manuals in pdf and html format. As I use it much more, I also...
  5. K

    Database

    Documentation > Data Management > Database Administration > Creating and Deleting Databases
  6. K

    Create static temp-table from dynamic temp-table

    The other comments in the thread aside, its actually not at all complicated, as you are probably aware; you just need something along the lines of the following demonstration code. It's very rudimentary with no cleanup or error handling; proof of concept only by someone with little experience...
  7. K

    qxoevent.p?

    Cheers Casper! <resists urge to insert new hidden 'Please log in' links in this post>
  8. K

    Create static temp-table from dynamic temp-table

    I scratched my head at first as well, as my first answer was 'no, by definition'. However I suspect Jamie wants to use the schema of a temp-table set up at run-time in later static code. eg. the way you might use ERD.
  9. K

    Create static temp-table from dynamic temp-table

    Not without writing unwieldy, complicated reflection and 4GL/df-creating code, I suspect. If you wait till you upgrade, there is the READ/WRITE-XMLSCHEMA() methods which would make the job easier perhaps.
  10. K

    qxoevent.p?

    Apart from asking in the right part of the forum, the question has already been answered. qxoevent.p is not in the propath when the error is thrown- the 'solution' you have just posted is not relavent (as it reads) to the problem you posted. It sounds very much like the administrator of...
  11. K

    Piew - Free Progress Code Editor

    Re: New version: Yep! Works fine - Excellent, thank you!
  12. K

    output cell in excel

    A quick rewrite for efficiency, and hopefully, readability (not comprehensively tested, and with documented limitations; expand at leisure...) FUNCTION GetColumnRef RETURNS CHARACTER ( input iX as integer) : /*------------------------------------------------------------------------------...
  13. K

    output cell in excel

    A fine example of looking at your code a long time after you wrote it, and thinking "What lousy comments." Basically, the 'if d = 0' bit caters for columns with a single letter. The alternative is for double letters (eg. 'CF').
  14. K

    output cell in excel

    Here's one I prepared earlier... FUNCTION GetColumnRef RETURNS CHARACTER ( input iX as integer) : /*------------------------------------------------------------------------------ Purpose: Returns the Excel column reference for (iX). Used for RANGE. Notes: eg. GetColumnRef(28)...
  15. K

    Piew - Free Progress Code Editor

    You, sir, are a star.
  16. K

    Piew - Free Progress Code Editor

    I really like the viewer, thank you, more useful for Progress files than my normal PSPad/NotePad++. Important functionality I would like: Print facility. One of the main reasons I used to use PSPad a lot was so I could print with coloured syntax. PSPad no longer works for me (it bugs...
  17. K

    10.2A compile warning message help

    Bitte schön. I used the downloadable knowledgebase from a couple of months ago. I tried to find a link to the solution online for you, but on the new site, I was unable even to find the knowledgebase...
  18. K

    10.2A compile warning message help

    So the fix is to remove the redundant code.
  19. K

    accumulate into weekly buckets

    You should probably establish some rep here before dismissing other posters. This question is not one of the atrocious ones (though ProgressTalk is not short of those) for at least 3 reasons: It's quite understandable to think you can order by the results of a function and do something...
  20. K

    Com-handles In Excel2000

    Please don't use txt spk. It's v irtng. We are mostly adults here. The Office applications (Excel etc.) have many, many attributes that can have various values, according to (eg.) what the appearance or behaviour of the document is to be like. Rather than having to remember each individual...
Back
Top