Search results

hi its the log file i need to truncate?

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 what command do i use to do this? its only 1 database so thought if something happens got it there rather than retrieving from tape backup. cheers tj

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

cheers Just wondering can some give me the safest way to rename the live databases? don't want to use mv command in unix. what is the proutil command? in regards to bulkload i looked at spreadsheet but dont have enough time to implement any code. but it will be considered for next time. but...

Hi It seems you are on V9, is this correct? We are on running progress v8 on unix. What is your OS? UNIX Why are you doing a reload? We are just re-indexing the database. The system is very old and the person previous to me done this on a yearly basis. Why do you need to recompile? Once the...

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

Thanks for the reply Thats a good way to understand it! So in my case where i want to develop ERP - Progress would be the one! But how about oracle and sap? Arent they just as good?

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 Thanks for reply Well that wont work as if i am doing a search say for locations between c30 and c40 it will still return location c4 along with the others between c30 and c40. It must take accoutn of all character combinations such as c4 and c40 and do the search based on that. So if i...

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

cheers I have finally got it working but have across another problem with excel data I am using Progress V8.2C as this is what the erp system uses. I also have v9.1d but does not let me run it as the version of the db is v8. I have a spreadsheet with a field with a number such as 4567324567...

Hi When you use xref is that used within the code or when compiling the program? cheers

Cheers Just wondering when i processing the excel i am going to go through each line but whats the best way to check when the last line has reached as i then want to leave the repeat loop: example is below: The code is BOLD is the loop which goes through the excel spreadsheet. cheers assign...