Search results for query: *

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

It means not to translate what is in quotes, it is for people who work with other languages. You would want to translate things like column labels and other text that is displayed to the user. Sometimes you don't want the text to be translated so you use :U so it won't get translated. An...

When you say millions of records, do you mean per day? Hour? Minute? Second? Of course a lot also depends on how you have your tables and indexes setup, how much data is in each record, and how you programs are coded. I can have 100 records and kill the database performance with a really...

Um, this assumes you have an index on both fields. If you don't have an index on DEF (test3), you might not get test3 when you do a last. This issue has come up big time on the PEG. Basically, if you want to see if there's a record in that table, find first/last is great. If you want a...

From what I understand, a Super Procedure is similar to an Internal Procedure except it loads into memory and is available to any program at any time - you don't have to have the code in that program to use it. Kinda like running another .p but that .p would be in memory. While these can be...

Ah, got it. Well, the only difference between regular tables in the database schema, temp-tables, and workfiles (work-tables) is how they are stored and for how long. You access all of them the same way. If I had a database table called Customers and wanted to list every field in that table...