Hi-

I have 2 questions from the code below.

Where do you come up with RDB$FIELD_NAME?

Is FIELDNAME part THE NAME OF A FIELD IN an actual TABLE AND 

RELATION_FIELDS THE NAME OF A REAL TABLE?

How can you use :RNAME IN THE WHERE clause?

Where is it getting its value from? It seems like it is just a variable

in psql without being assigned a value.

I am doing a little reading of psql, but I am going to take a break

for a while. It is a nice day out. Not too many more before fall/winter

set in. 

thx for any assistance - jim

...

AS

   DECLARE RNAME CHAR(31)

   DECLARE FNAME CHAR(31)

   DECLARE C CURSOR FOR 

(SELECT RDB$FIELD_NAME FROM RDB$RELATION_FIELDS

WHERE RDB$RELATION_NAME = :RNAME

ORDER BY...);

SELECT 

INTO :RNAME DO

BEGIN

OPEN C;

...

END

END

partial example found in cursor section of helen borriie's psql book.