Recent content by popsin

Sorry for my ignorance but what does TS stand for?

It's very strange but it doesn't matter if you use agregation or not. I tried to run quite a simple program against that table, something like: FOR EACH table: DISPLAY key_filed. END. And I know for sure that key_field does not contain null values. As I said, procedure runs perfectly when...

Well the problem is not in the FOR EACH itself. It's fairly easy query like: FOR EACH some_table BREAK BY some_field: Problem is that whenever you reference that table the program returns error: ORACLE error -24347 see "ORACLE Error Messages and Codes Manual". (1252) ** Warning of a NULL...

Thanks everyone for suggestions but I really had to do it that way. The corresponding 4GL way (FOR EACH...) returned me an error. So I solved the problem by outputing result of the SQL query into a flat file. Then loading that file into a temp-table. Looks ugly, but solves my problem :-) I also...

Thanks Jupiter, I got the same idea myself but I thought that there was something less cumbersome than that.

Hi, Can somebody tell me how to use result of a SQL select statement in a Progress 4GL procedure? When I run procedure with SQL statement it shows me results on the screen but I don't know how to put that records into a temp-table for instance. I tried to find something in documentation but no...

Hi, I have progress 9.1b database on UNIX server. An old 4GL application is connecting on that DB from a PC. Now, I want to make an ASP application that connects on that same DB but from another PC which is our Web server. I am using OpenLink Lite ODBC driver (version 4.2) to connect...

How to setup a service that starts the broker?

Hi, I have the following problem: I have Progress 9.1C database on Unix SCO Server. I am trying to connect that database from Windows 2000 Server through Merant 3.60 ODBC Driver for Progress but it doesn't work. I have configured everything as described in the manual but it doesn't work...