Search results

  1. T

    creating file to output to in Progress 8

    cheers that worked a treat so why does it not work under the stream method?
  2. T

    creating file to output to in Progress 8

    hi is it the same in unix? filename = "/test/" + "invSara" + TRIM(STRING(day(TODAY))) + TRIM(STRING(month(TODAY))) + TRIM(STRING(year(TODAY))) + ".txt".
  3. T

    creating file to output to in Progress 8

    Hi I am trying to output to a file using PUT statement but it does not seem to work. Basic code below: -------------------------------------------------------------------------------- def var filename as char no-undo. DEFINE STREAM stOrd. filename = "invSara" + TRIM(STRING(day(TODAY))) +...
  4. T

    Temp table populating problem

    only finds 1 record for the 13,000 quantity just need to make it unique and not overwrite existing details as the details are the same
  5. T

    Temp table populating problem

    no records are found when i do the for each loop where kdel-ref = ""
  6. T

    Temp table populating problem

    Hi I have a temp-table defined in my program. I am populating this using data from various tables. But i have come across a problem which causes the record to be overwritten. I have data such as below qty vardesc order kdelref 144,000 20001111...
  7. T

    date format in excel spreadsheet

    Hi i have created a report which outputs to excel. But for some reason when i export some of the cells are im mdy format but others are dmy. i need it in dmy. but when i message the data is shows correctly how can i resolve this one?
  8. T

    Height of frame in character

    Hi I have a form which is displayed in a frame as shown below. But i cannot increase the height as i need to add one more line. Its not showing. How can i get round this one? form w-suf[1] = "fred" w-suf[2] = "tom" ....... w-suf[19] = "pete" with frame f-suff centered no-labels...
  9. T

    date format

    hi if i message that out i get dmy. how can i change this format as above? regards tj
  10. T

    Excel com object add worksheet

    Cheers works now ok now if i have spreadsheet with 3 sheets on it already how can i append to start from the 4th sheet. when i do it now it puts sheet4 right at the front before sheet1 cheers]
  11. T

    Excel com object add worksheet

    Hi heres my code but it does not work brings error Invalid component -handle referenced while processing method/statements Worksheets chWorkbook = chWorkbook = chExcelApplication:Workbooks:Add(). chWorkSheet = chExcelApplication:Sheets:Item(1). chWorkSheet2 =...
  12. T

    Excel com object add worksheet

    Hi What is the attribute to create a new worksheet within an excel spreadsheet cheers tj
  13. T

    date format

    Hi My progress version has the date format as dmy. but for one particular program i need it to be yyyymmdd e.g. 2008/12/30 but i cannot do anything with the -d parameter on a target string. is there any other ways around it? regards TJ
  14. T

    changing field length in database

    Hi Just wondering what would i need to do if i changed the length of the field in the database? whats the best way to do this? regards tj
  15. T

    onlie database backup progress 8.1e

    hi i know what the problem is now. the size of the tape iis 2gb and we are going over that! lovely unix does not tell me anything like windows! ;p But i have trncated log files which were big and the backup has run just need to do some housekeeping on the data. We are moving onto a new server...
  16. T

    onlie database backup progress 8.1e

    Hi Wish we could upgrade but the ERP that we run is old and caanot be run on openedge we do not have after-imaging so can not do probkup is there any other way?
  17. T

    onlie database backup progress 8.1e

    Hi My backup has been failing so was wondering if its possible to do an online backup like in v9 upwards could some one please give me commands cheers
  18. T

    truncate log file in Progress V8

    cheers worked a treat just another one how about if i wanted to keep the last 100 lines in the .lg file can this be done?
  19. T

    for each loop

    cheers all sorted now
  20. T

    for each loop

    Hi I need to determine in the if loop to see whether the program needs to use the req.date = jp-date or conf.date = jp-date. This is determined by the conf.date How can i do this?
Top