Recent content by velvettiger

  1. V

    Creating temporary tables

    Hi Guys, I was wondering how would you go about creating a temp table with the fields card number and spend ?
  2. V

    Making Code Run Faster

    yes it is repeatable.
  3. V

    Making Code Run Faster

    Hi Thanks for all of your advice, So i checked through the database and i realised that there is an index on donor-card-no, so I placed that first in the field list. I also made some changes to the code- please see below code-. The code compiles and runs but I am getting the a text file...
  4. V

    Making Code Run Faster

    Hi everyone, So I am really new to Progress and I was wondering if there is a way to make the below piece of code run faster. I know that you could use an INDEX but when i looked in the help it is soooo confusing. Can anyone shed any light. Thanks a lot OUTPUT TO C:\cal\custTT.TXT...
  5. V

    Indexes

    Hi Guys, When I run the below query I am getting the following message being output in my text documents. MESSAGE Field 22 from customer record (recid 80255026) was missing from field phrase. OUTPUT TO C:\cal\ALLTRANSACTIONSEXCEPTSC_TUESINDEXS.TXT. SESSION:DATE-FORMAT = "ymd". FOR EACH...
  6. V

    Using 'in'

    Hi Guys, I am trying to use the 'in' keyword in progress and I think the way I am using it is incorrect. Can anyone point how how you would use the equivalent in progress? Any help is greatly appreciated. OUTPUT TO C:\cal\Barbados.TXT. SESSION:DATE-FORMAT = "ymd". FOR EACH...
  7. V

    Using 'Like'

    Hi guys, I am new to Progress and I want to use the 'like' keyword. I tried using it like I would when I write sql statements because I know that it is somewhat similar. Does anyone have any suggestions OUTPUT TO C:\cal\Antigua_CFL_OR_SHELL.TXT. SESSION:DATE-FORMAT = "ymd". FOR EACH...
  8. V

    Learning Progress

    Hi Everyone, I am interested in learning Progress and I was wondering if you guys know of any tutorial that I could use online.
See more
Top