Recent content by richtpt

Sorry, I'm having troubles finding my code for doing this. Opening in Word was easy, printing wasn't because we didn't want the file to open in word, just print. I remember we got it to work, now I just have to find that code. When I do I'll post it for you. Rich

Sure, send it to richard.uchytil@cenveo.com.

If I understand, you want to be able to print a word document from Progress, and open a word document in word, correct? What version of Progress do you have? Rich

I'm not sure I follow. Are you trying to search for part of a word, like "cov" in "coventry"? If so, there are a couple ways to do this. One is to use BEGINS. This will find all records where the field begins with whatever you want, such as "cov". FOR EACH table NO-LOCK WHERE table.field...

Check the Progress Knowledgebase on their website http://www.progress.com - I know it's possible, but I've not done it. Sorry I'm not more help. :( Rich

We have many different databases (training, test, live, long term testing) and have a .pf for each database. As Mike said, just copy your .pf to a new name, change the database connection in there and use that one for your other connection. Rich

Then you should be able to use the REPLACE command for that. vstring = "AB&C Company". vstring = REPLACE(vstring,"&"," "). Rich

Depends on what you are trying to do. MATCHES will tell you if that character/string is in the string - returns true or false. INDEX will find the first occurance of that character in the string and tell you what position it is. Say you have a string that's "Fred&Barney" and you want to...

Ah, true, yes, that extra space will cause a problem. Here are two other options. One would be to completely remove the comma but leave the space: vstring = "Cleveland, OH 44041". vstring = REPLACE(vstring,",",""). Now each piece of information is separated by a space so you can do...

Been there, done that, seen it many times. I was told many years ago to use REPEAT TRANSACTION ON ENDKEY UNDO, LEAVE: In v6 that worked great, but doesn't seem to work right anymore. Now anytime I import, when I leave my repeat loop, I simply do a DELETE temp-table. I know there's a better...

WELL, if you know it will ALWAYS be in that format, then assign City = entry(1,vstring,",") State = entry(1,ENTRY(2,vstring,",")," ") zip = entry(2,vstring," "). Another idea is this. Get rid of the comma: assign vString = replace(vstring,","," "). Now the comma is gone and...

That's a good point. It all depends on what you're doing and how much data you think might end up in the table. Rich

Depends on how many records you're putting into the temp-table. You don't always need an index. I've tried putting about 2,000 records in without an index and with an index, and I didn't see enough of a difference to make using an index a must. If I were doing 10,000 or 100,000 records or...

You will want to use a temp-table instead of a workfile. Workfiles are in memory only and if you fill up the memory set aside for the workfile, your program will crash. Temp-tables will use memory first, but then go to disk if needed. Rich

Contact your local Progress representative. If you don't know who that is, go to http://www.Progress.com and either find your representative or send an email to Progress, they can help you. Rich