Search results

Tom, I've found the solution (error in fact), and I have to clarify this topic. (Un)fortunately that's not true that Progress does not support "INSERT FROM SELECT" statement. Progress'es documentation (Progress SQL 89 Guide and Reference, page 61) says: "The INSERT INTO statement inserts one...

No, this is a stanalone query from the "query window". I know that it is a must to commit such operation in other RDBMSes. I do not know how to commit in PROGRESS (I get the error described above). I write the query, press F1, database performs calculations, and finishes. After that I try to...

Hi, I try to select data from one table and insert into another using one query. I've made it like this: INSERT INTO z_conversion01 (emp-no, month, year, comp-amt) SELECT emp-no, month, year, SUM(comp-amt) FROM p_sal_comps WHERE year > 2006 AND comp-no IN (403, 409, 465...

Tom, thanks a lot for help. I've made it this way for the first day: /************ FUNCTION GetFirstDay ********************/ FUNCTION GetFirstDay RETURNS DATE (INPUT i_date AS DATE, i_months AS INT). DEFINE VARIABLE c_month AS INT. DEFINE VARIABLE c_year AS INT. DEFINE VARIABLE c_date AS DATE...

Hi, I have the following problem: I have to calculate the first and the last day of the month, which is X months before given date. For example: today is the 6th of February, 2007, and I have to find the first and the last day of December 2006 (given date - 2 mths) to extract payment...

Thanks a lot. I asked google, but the results were very poor :(

Hi, I have the following problem: I have to create a query (SELF-JOIN - f.e. using BUFFER) and write its output to file (f.e. using PUT UNFORMATTED). This is the SQL syntax. Can you help me with rewriting it to Progress 4GL (as I know this is the only way to write output to file, because...