Search results

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))) +...

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...

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?

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...

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

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

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

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

Hi I need to truncate my log file. I am working in Version 8 but prolog command does not work This needs to be done while databases are running. I am working SCO UNixware 7.1.1. any ideas? regards TJ

Hi Just wondering if this is possible. I have a for each loop like the following: for each poi where poit.kco = 1 and poi.req-date = jp-date) no-lock: but i need to do a check to see if a different date is filled in if it is then i will use that date (conft.date) otherwise...

Hi How can i rename databases as i just want a backup of them if anything goes wrong when i dump and reload the data regards Tej

Hi Im going to be dumping and reloading databases this weekend. Dreading it a bit as it will be my first time. We have a script in place which has been written by the previous programmer. I have posted this script below does this look correct? I have a few questions: 1. how do you rename...

Hi I have a loop in my code which goes through each job and extracts the relevant information for labour. there is a temp table which gets populated so that data can be outputted called ptjobs. But the problem i have is that when adding the labour quantity together it loop sthrough 9 times for...

Hi If i was going to go down the path of developing software which requires a database i need to decide why using Progress would be better than the technologies out there such as C++, VB etc.... Like to know peoples thoughts on this. Having worked in companies using progress i know cost is a...

Hi I have a program which produces a report. I havea table which stores labour details for different types of people, in my case checkers and printers. But what i need to achieve is a list of the checkers with their jobs which is fine. But then i need to use the same table using the buffer to...

Hi I am using character based progress at my company. ok i have a table for stock where the location is set to e.g c20, c110 etc but when i run a query on the table if i check location >= "c30" and <= "c40" it shows the records but it also includes "c4" which i dont want any ideas? it just...

Hi I have some code which basically produces a receipt report. But i want to exclude some orders which end with 'X'. which is easily done as i am currently exlduing orders which end with 'b'. I was thinking to do the normall processing but when it comes to an order with an X, to populate a...

Hi I am developing in character based progress. I am working on a program and have come across an error. Its a report which currently has 15 machines under which there are lots of differnt calculations. Arrays have been used. When i started to increase the extent of the variables it got to...

Hi I have a program which currently prints onto a despatch sheet using dot matrix printer. It prints out fine. But when i try to add an additional line to the end it moves the address name across for both delivery and invoice. I added the code below: ( the line in red is the one i added as...

Hi I h ave created some code for a report but just takes ages can anyone see if they can find a faster way. There are lots of indexes for tables. I need to run it for 6 months but one day takes ages. DEFINE STREAM stOrd. define temp-table tt-Orders field ttord-date LIKE...