Search results

  1. K

    Question Duplicate/clone/re-route A Stream

    Me again. There was no way round this, so I folded and opted to put the stream to a file initially, then I can copy it to an archive, and also send it to the printer. Seems a bit manual to me, but still, it works. And it wasn't as complicated as I suspected, so all it good!
  2. K

    Craziest Progressism?

    ...and technically DEF VAR v_Logi AS LOGI. v_Logi = ?. is a Progressism - what other languages have a three-state boolean?
  3. K

    Craziest Progressism?

    What about: RUN program.p(INPUT v_Var1, OUTPUT v_Var2) (v_RandomVariable). This compiles fine...
  4. K

    Question Duplicate/clone/re-route A Stream

    Thanks RHD. I did experiment with stream handles last week, and while you can't change the location of the stream, you can switch the output of a stream-handle between two streams: DEF VAR hprnt AS handle NO-UNDO. DEF STREAM stream1. DEF STREAM stream2. OUTPUT STREAM stream1 THRU VALUE("lp...
  5. K

    Use Variable As Table Name In Find First

    ForEachInvoiceDelete: we do just that for a HUGE statistics report program - it was before we found out about dynamic queries, and we just haven't got round to changing it yet... Works quite well, except when things go wrong! Luckily it's just a report and not actually changing any data!
  6. K

    Question Duplicate/clone/re-route A Stream

    Hi All, Yet another teaser that's been bugging me lately. We have several documents that we print in postscript directly to a cups printer using OUTPUT STREAM prnt THRU VALUE("lp -d" + v_printer) and then PUT STREAM prnt UNFORMATTED v_Postscript SKIP. Those "put streams" are littered...
  7. K

    Find string entry in another string list

    Thanks all for the replies. I've been doing some experimentation, and it turns out you can't use word indexes/CONTAINS in FIND statements... Also, you can only create an index on the search field, so doesn't include any other fields I need. Back to the drawing board.
  8. K

    Find string entry in another string list

    @TheMadDBA - I'm just reading through the Progress documentation about CONTAINS, and it seems like that will actually do the job - Thanks!. We've never used it before, and I can immediately think of a few places where it might come in handy and maybe speed things up. I've just had a look at...
  9. K

    Find string entry in another string list

    Hi All, I haven't posted for a while, so thought I'd tax your brains a little today (as well as test my luck!)... I have two comma separated strings that I need to compare. Assume one string is a list of item composition attributes (ie, wood, plastic, metal, glass, etc). The other list is a...
  10. K

    Code Beautifier for Progress 4GL

    Is this no good? http://sourceforge.net/projects/progress4gl I use NPP, and would try this now if I wasn't looking for something else right now... maybe later...
  11. K

    Answered Generating a QR Barcode

    Just for information purposes, here is a postscript library for barcodes, including QR codes: http://bwipp.terryburton.co.uk/ Not really from OE, but it fit quite nicely in our postscript generation process in OE...
  12. K

    CRC calculation

    I know I'm resurecting my old thread, but the ENCODE() function works... ;-)
  13. K

    Periodic Database Slowdown

    This is a little old and we solved it. Thanks all for responses, we upgraded to 10.2b, and the issue seems to have gone away. We did also change the blck size as well, so not sure exactly which one fixed it... Cheers!
  14. K

    shared variable - bad ?

    @Marian: Correct me if i'm wrong, but it seems obvious that using persistent procedures or static classes creates a dependency on something outside the program as much as a global variable does? For something like the userid, to me this seems ideal...
  15. K

    Empty Temp-table

    Is it just me, or could you just do for each table : delete table. end. Whats the difference between EMPTY TEMP-TABLE and just deleting?
  16. K

    shared variable - bad ?

    We use shared variables, but only to indicate the user of the session, or if we are in debug mode or something like that. Rather than passing these values from program to program via parameters, it makes sense for us to do it this way...
  17. K

    For Each x = 1 to 10

    Hi All, This is just something I noticed in passing (caused me a real headache!), so just throught I'd share it. I only needed the first 10 or less rows of a table, so for each table /* where clause */ x = 1 to 10 : /* do processing */ end. At the end, I checked x...
  18. K

    Periodic Database Slowdown

    Re: New here...Where Should I Begin? @Addedowitoext: Hello, and welcome. You might want to try http://www.progresstalk.com/forumdisplay.php?81-Chit-Chat, this is the wrong forum for introductions. @all: Right, scrap the -spin value, doesn't work at all for workgroup, so we are stuck with the...
  19. K

    Periodic Database Slowdown

    @cj_brant: At the moment, upgrading is a good idea, will have to look into that... I don't collect table stats - what would that show and I take it thats from one of the system tables? The db has 1024 block size, so yes, you're right with 30000 buffers means about 30mb - could do with a lot...
  20. K

    Periodic Database Slowdown

    Hi Tom, The buffer hit ratio is only at that during the slowdown (normally its actaully around 95+), at which point we can't identify the issue (what with various logging going on now...) Sorry, I should have said we did follow their advice, and set the -B to 30000 as they recommended. My...
Top