Recent content by ank123

  1. A

    Remove space from string.

    How to remove spaces from a string "AAA BBB CCCC" and need to convert this to "AAABBBCCCC". Regards
  2. A

    Question Performance issue

    Thanks for your reply. I have never used these tools. Could you please suggest where can I read more about ProTop, VST and Prifiler to understand detailed usage of this? Thanks again BR
  3. A

    Question Performance issue

    This is related to 4GL programs. There are few programs (report and maintenance) which take very munch time to get completed. These are taking hours to be completed. Please suggest what are best ways to find out causing this problem and how can this be fixed. Mainly how can i check if indexing...
  4. A

    Question Voucher Maintenance program

    Hi All, I am just beginner in mfg/pro. Our customer is having customized program for Voucher Maintenance program. Now required table(s) are not getting updated properly. According to him: All Voucher are with PO/Receiver and along with that user enter some discount amt. in Distribution...
  5. A

    Lock Table.

    Can somebody tell me, What is the Lock Table Overflow? How can we avoid this? Thanks in advance.
  6. A

    Reducing the transaction size.

    Hi Medu, thanks for the reply. Do we need to use define query .. to get this done? Can we not do using for each ..End as in my original query? Thanks
  7. A

    Reducing the transaction size.

    define buffer bcust for customer. -- -- MAINBLK: do transaction on-error, undo MAINBLK: for each bcust exclusive-lock where bcust.id = 10 and bcust.rcode = 5: assign bcust.discount = 1.5 ---- ----. end. end...
  8. A

    Some basic progress queries.

    Hi Tom, I am not forcing you to respond to my queries.Alos this not necesarry to respond to anybody's thread without answering the queries. :-) Hope you will undersnatd this. Regards
  9. A

    Some basic progress queries.

    HI, Kindly answer me on following querier - 1) Fastet way to count the records in database table. 2) Without putting the exclusive lock can we modify the record? 3) Advantage and disadvantage of a frame, multiple frames? 4) What is META information? 5) How can we check what transactions are...
  10. A

    Matches & Contains

    Hi, 1) Could somebody tell me the differences among Matches,Begins & Contains? Thanks in advance ank123
  11. A

    Transaction

    Does this mean, if error occurs at 5th record iteraton then updation for all 5 records will be roll backed? I am new to progress, so Kindly eleborate this on me. Could you please provide me some good examples on transaction scenerios? Thanks in advance.
  12. A

    Transaction

    do transaction: for each customer exclusive-lock: update customer. end. end. Consider that there is some problem occured while updating the 5th record. What will happen in this case? Will updation for all the 5 records be rollbacked of just for 5th record? I'm having doubt because...
  13. A

    Text File Manipulation

    Hi, Please provide me the solution on my query below : datafile.txt AcctNum,code,Region,,,, 12345451,AN ,abaab 12345452,AN ,xccxc 76677545,RP ,acxcc 43567878,RP ,afghh 32190900,AN ,afrfrf 87312345,AN ,aqaw I have a text file (datafile.txt) which has data with above...
  14. A

    Record scope

    Hi, There are Strong,Week and free scope. Practicalliy i could find out the where should we use these? Could somebody explain me with example? Thanks
Top