Recent content by Mark123

Thanks. I also have another question: How can I to put data-time into where clause , something like this: For each mytable where (create_date + create_time) > "05/29/2009 14:22:24" display fileld1 filed2 string(create_date, "99/99/9999" ) + " " + string(create_time, "hh:mm:ss")...

We have 2 separate fields update_date which is like 05/29/09 and update_time like 64,430. How can I display them like 05/29/2009 17:53:50 ? Thanks.

I ran your code, burt received another error "Incompatible data types in expession or assignment. (223) Could not understand line 3. (196)" If I comment the line with (if active ... the code runs fine.

Hi, I am trying to convert all "yes" to 1 and all "no" to 0 in a case statement. Here is my code: for each prospect where: display prosp_id name address active case active: when "yes" then 1. when "no" then 0. end case. skip. end However I receive a message "Line2. Colon followed by...

Hi all, My questions probably sound too primitive, but I am relatively new to Progress and I found some problems while deveoping 4GL code for it. Generally speaking, I am creating a dump file from a Progress table with pipe-separated columns. Here is what I am doing: for each prospect...

Hi. I need to format dates in YYYYMMDD, how can I use FORMAT for it ? Thanks.

Wow ! It's so huge, I did not expect so. Thanks a lot Cecil, I copied it and will try to implement.

Hi, I need to perform a cross-tab of data in Progress 4GL. I have a table like this, it's called sales: seq city date sold ---------------------------- 1 New York 02/01/07 123 1 New York 03/01/07 125 1 New York 04/01/07 128 1 New York 05/01/07 132 1 New York 06/01/07 140 1...

Thanks Rrojo, but RUN command is to call it from Progress or Unix ? I tried to RUN it from Unix (ksh shell), but received a message ksh: run: not found. My procedure is not stored in Progress database, it is saved in Unix, actually it is a script not a procedure, and I have to call it from...

Hi, I relatively new to Progress. I wrote a Progress 4GL procedure which is actually a script saved in OS (not in database). Now I need to change it to accept input parameters. Can someone point to an example or paste code snippet here ? Thanks.

Elliot, This is actually not so bad news, we have SQL Server 2000 in our environment as well, so if it is impossible to connect Progress to 2005 I am going to do it to 2000 and then upgrade with detach/attach or backup/restore to 2005. So let me ask you the next question: how to connect to...

Hi, I have to migrate our existing Progress databases to SQL Server. As far as I know there are so called ODBC drivers (or something like that) that may help in such migration to move data from Progress to SQL Server. My environments are : Progress version 9.1e running on Unix. SQL Server 2005...

Thanks Cecil, I used both your queries as templates.

Hi, I am new to Progress and I need to convert the following SQL query into progress 4GL language: update table1 set col1 = 2, col2 = getdate() where col1 = 3 Thanks in advance.

Thanks, it worked