Search results

  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

    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...
  3. 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...
  4. A

    Lock Table.

    Can somebody tell me, What is the Lock Table Overflow? How can we avoid this? Thanks in advance.
  5. 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...
  6. 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...
  7. A

    Matches & Contains

    Hi, 1) Could somebody tell me the differences among Matches,Begins & Contains? Thanks in advance ank123
  8. 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...
  9. 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...
  10. 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
  11. A

    New empty DB.

    Hi, I want to create new empty database and i have .df file for same. Please let me know the steps to make this done. Do i require some more info except .df for this? TIA
  12. A

    Update the records

    Hi, I want to update all the records for discount = 10 in a table. Please let me know the best way to perform this. Is the following query efficient for this if not then please let me know the reason - For each customer exclusive-lock: assign customer.discount = 10. end. TIA
  13. A

    Transaction

    Hi, I am new to progress so please help me ot write a query for below requirement. There is a table having thousands of the records and i want to update all the records so i want to write a query so that 200 records get committed at a time.Once changes made for these 200 record then another...
Top