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!

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

Recent content by richtpt

  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

Part and Inventory Search

Back
Top