Search results

  1. anandknr

    Question Import from a dynamic CSV

    I am trying to read a csv file which can be of 'n' number of columns. My requirement to read first column and then based on its value I need to consider/ignore that row. At the end, I will create a new csv file which have same columns as first one, but only with selected rows. Issue I am Facing...
  2. anandknr

    Question Replace Exact Words

    Hi All, Is there a function available in progress which will replace only exact words but not portion of it. I believe there is not. define variable pcString as character no-undo. define variable pcErrorWord as character no-undo. assign pcString = "customer is abbreviated as cust."...
  3. anandknr

    Question Decimal formatting

    Hi all, A basic question here - I have some difficulty in understanding a format usage of ">" Vs "9". For example; why below two statement outputs different values ? string(3.1634567,'>>>>>.99<<<<<') is 3.163457 and string(3.1634567,'>>>>>.999<<<<') is 3.1634567
  4. anandknr

    Question contains operator

    Hey all, I have a query on CONTAINS operator. define temp-table ttTest no-undo field textFld as character format "x(30)" index idx as word-index textFld. /* Entered below data into ttTest, each line each record. hello world hello planet hello ??? y is a word y/n is a word */ for each...
  5. anandknr

    Non unique index as primary index

    Hello all, I am writing a query to list all tables with no unique and primary index defined. define var havePrimary as logical. define var haveUnique as logical. for each _file where _file._tbl-type = "T": assign haveUnique = can-find(first _Index where _index._file-recid = recid(_file)...
  6. anandknr

    Question Inbuilt Functions

    Hi All, Just want to confirm if any inbuilt function (or a better version of user function) available for below tasks. Check is a given word is in UPPER case or not? function checkIfUpperCase returns logical (input inputString as character): define variable isInUpper as logical...
  7. anandknr

    Question spell checker

    Hello All, I am planning to add a spelling validator (spell checker) in my 4GL code. Can I do that? I browsed through a few "Spell Check" posts here and almost all of them are pointing to Microsoft Word Spell checker. I have my application in an unix enviroment and hence I cannot do that :( I...
  8. anandknr

    Question Schema analyzer

    Hi All, I have to programmatically parse the schema defeniton file (.df file) to analyze various things. (For example, list all fields with HELP is missing, spell check all field names). Is there any way to acheive the same? Basically I am planning to write a progress procedure which will...
  9. anandknr

    Question Schema Parser / Validator

    Is there any API available to programatically parse / validate / analyze the schema file (.df). My need is like to, check if field help is missing, check and confirm field naming standards etc:-.
  10. anandknr

    Question catch 915 error

    I would like to know if there is any way to catch the error: Lock table overflow, increase -L on server (915) Below is an example I am using to create such an error condition. I know this will be a bad example, but all i need was to produce 915 error. def buffer bacctg for acctg. do...
  11. anandknr

    Index and Key

    Hi all, A little confusion here. 1. What is the concept of keys in progress and how it differs from index. (gsdbe.pdf points about both) 2. Do we have any key constraints available (like foriegn key constraint) ? 3. Primary index accepts null value when i tested. (not as per gsdbe.pdf, chapter...
  12. anandknr

    Repeat and Do blocks- Transaction

    Hi All, The main difference b/w Repeat and Do block is Repeat by default have transaction property. D:\WRK\prog\test.p 02/20/2010 00:13:36 PROGRESS(R) Page 1 {} Line Blk -- ---- --- 1 1 do : 2 1 find first customer . 3 end . 4...
  13. anandknr

    list files in a folder

    Hi All, I need to populate a temptable with the path of all text files in a folder. Is there any easy way in progress to get the list all the .txt files in a folder.
  14. anandknr

    Stunnel SSL wrapper

    Hi all, Have anybody used Stunnel at client side for SSL wrapping of data. Today I have started to work on this and encountered few issues. 1. I already have Stunnel installed in my REDHAT machine ( which already came from linux installation I guess ), but when i checked /etc/stunnel...
  15. anandknr

    Streams Concept

    Hi all, Can somebody help me to figure out the actual concept/purpose of stream. The only thing that I have done with stream is to read/write files. I know there is something more than this about stream can do. Please share.
  16. anandknr

    XML Request and Respose

    Hi All, I have a windows VB based Application working on XML requests and response. It simply send out and xml request file and waits for the response xml then displays the request xml and response xml side by side. What i need is to do is to use this in my web project. So I am...
  17. anandknr

    XML Request and Respose

    <Same post is cross refered under Development, sorry but no option to delete this post> Hi All, I have a windows VB based Application working on XML requests and response. It simply send out and xml request file and waits for the response xml then displays the request xml and response xml...
  18. anandknr

    Num-Copy in Printer output not working

    How to get printer dialog value Hi All, I was trying to get the user input value from a system dialog for printer. PLease see below my code. DEF VAR v-ans AS logi . SYSTEM-DIALOG PRINTER-SETUP NUM-COPIES 3 UPDATE v-ans ...
  19. anandknr

    Appserver Pf file

    I am sure this is a simple query. Yet I am stuck on this . I have my background process running from appserver. This process have the date format as "dmy". I need to change it to "mdy". But i could not find a pf file set for App server. So from where will it pick the -d param ? and how can i...
  20. anandknr

    Progress Knowledge Base

    Hi all, Previously i was using an online version of Knowledge Base from progress.com. Now it seems the url is no longer valid or they have updated their site. Any have a working url for the same ?
Top