Search results

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

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

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

Hi All, Sorry for the long post, but we're a bit stuck! We have a situation where we get a slowdown of the database. This seems to happen randomly during the month/year, but always at the same time range during the day. Our customer has a workgroup license (10.1b) and database size is around...

Hi All, Has anyone done any CRC calculation with Progress? I need to send an image to a Zebra printer, and it insists on needing a crc-ccitt string is 4 digit hex. I have a VB example that I am trying to convert to Progress, but it is going to involve a lot of fiddling with "fake"...

Hi All, I have a requirement where I need to be able to add/update and delete records inside a transaction, regardless of the outcome of the transaction - the record must be changed no matter what. Now, I can use RELEASE for adding/updating, but what do I use when I want to force the...

DEF VAR v_Date AS DATE NO-UNDO. v_Date = DATE(MONTH(TODAY),13,YEAR(TODAY)). REPEAT : IF WEEKDAY(v_date) = 6 THEN DISPLAY STRING(v_Date,'99/99/9999') FORMAT 'x(10)' LABEL '"Friday the 13ths"'...

Hi All, We are again looking at timezones and I have a quick question that maybe someone can answer... We have a system that is (currently) accessible across 3 different timezones (GMT,-4h and -5h), and have just about figured out a process to store/retrieve the correct date/time for all...

┌─────────────────┐ │12:34:56 07/08/09│ └─────────────────┘ :)

OK, probably the wrong section, so sorry if it is... We have been playing around with external reporting tools using the progress ODBC drivers, and came across one bit of software that would only connect to MySQL. So we dumped a stats table and loaded it into MySQL, and did some analysis. We...

Hi All, I have recently discovered something that i think may be of interest... I believe that FIND NO-LOCK gets the record and then stores it in memory. Then, when the actual record in the database is changed, it doesn't update the copy in memory until you do another FIND. For example, I...

Hi all, I got a strange message from one of our users logs yesterday: WARNING: Could not read database record for undoing. (1750) I have no idea what this means or how to diagnose the problem... It occurred in a regularly used, but minor, portion of the system we run, so it is not that...

Hi all, We have a customer in the US (-5 hours), and we would like them to run on the same server and version of progress as one of our UK customers, and also their partner. This creates problems such as the date format and the time difference issue. We solved the date format by using...

Hi all expert progress users! Sorry, this is a bit long, but I hope that this taxes your grey matter a little in a good way! I have a requirement to do a daily replication and backup. Not sure exactly how to go about this, so here are my results so far. Basically, we would like a server to...