[firebird-support] basic cursor and firebird psql question

2015-10-12 Thread thirdshiftco...@yahoo.com [firebird-support]
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

Re: [firebird-support] basic cursor and firebird psql question

2015-10-12 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
At 06:43 a.m. 13/10/2015, thirdshiftco...@yahoo.com [firebird-support] wrote: >I have 2 questions from the code below. > >Where do you come up with RDB$FIELD_NAME? It is a column in the system table RDB$RELATION_FIELDS. The RDB$-- tables exist in all Firebird databases. They store your