Search results

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.

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.

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

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.

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

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.

Hi, I am new to Progress and trying to create a progress code for the following SQL analogy: select pp_acct_rep, counts = count(*) from tt_mismatches group by pp_acct_rep order by pp_acct_rep Here is what I am trying to code, but every time I get a wrong result ...

Hi , I am new in Progress, and want to ask if there is a index hint in Progress, either in 4GL or SQL ? If yes, how can I use it ? I am working with version 9.1 on Unix. Thanks, Mark