table name alias

Posted by Admin on 08-Oct-2007 10:14

I'am new po Postgress and I have a question:

Suppose I have two tables: RedData and BlueData.

I can do nested loops like this:

FOR EACH RedData:

DO:

DISPLAY RedData.

FOR EACH BlueData:

DISPLAY BlueData.

END.

END.

END.

Thus I have the BlueData-loop nested inside the RedData-loop.

But how to nest a BlueData-loop inside a Blue-data loop?

If it was possible to give an alias for a table it would be a problem.

Is it possible???

(I haven't found it in a Progress Manual)

Maybe there is an another solution?

-tt

All Replies

Posted by Admin on 08-Oct-2007 10:29

The alias you are looking for is a buffer.

DEFINE BUFFER OrangeData FOR RedData.

DEFINE BUFFER GreenData FOR BlueData.

Mike

This thread is closed