Recent content by tjsingh

  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...
See more
Top