Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. richtpt

    Auto print command

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

    Database ...select

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

    Auto print command

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

    Database ...select

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

    OpenEdge and Crystal Reports

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

    Parse String

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

    Parse String

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

    Parse String

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

    Parse String

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

    Converting data

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

    Parse String

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

    How do i use a workfile

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

    How do i use a workfile

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

    How do i use a workfile

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

    Progress 8.3 Software

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

    :u parameter

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

    Progress Engine's Performance

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

    SIMPLE ?? Solution

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

    super procedure

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

    How to read a working table

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

Part and Inventory Search

Back
Top