Firebird table field name list
lazarus / 16-Databases

----------------------------------------------------------------------
TRNelson · 2016-02-18 01:51

I would like to return the names of the fields of the table.  I
execute the following SQL command and it returns no information.

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i SELECT
RDB$FIELD_NAME FROM RDB$RELATION_FIELDS WHERE
RDB$RELATION_NAME='tablename';
Am I missing something here?

----------------------------------------------------------------------
taazz · 2016-02-18 01:59

No, that seems correct. Keep in mind that firebird is case sensitive,
so Tablename <> TABLENAME <> tablename etc.

----------------------------------------------------------------------
TRNelson · 2016-02-18 05:28

Quote from: taazz on February 18, 2016, 02:59:06 amNo, that seems
correct. Keep in mind that firebird is case sensitive, so Tablename <>
TABLENAME <> tablename etc.
Okay, that solved that then.  I have the table name coded as a CONST
with all lower case chars.  All my other SQL statements in the program
work just fine with the name being like that.  Seems to be an
inconsistency here. 

Thanks!

----------------------------------------------------------------------
balazsszekely · 2016-02-18 05:30

Quote@taazz
Keep in mind that firebird is case sensitive, so Tablename <>
TABLENAME <> tablename etc.To be more precise only quoted identifiers
are case sensitive, non quoted identifiers are not, and are
transformed to upper case.

----------------------------------------------------------------------
TRNelson · 2016-02-18 14:37

Quote from: GetMem on February 18, 2016, 06:30:37 amQuote@taazz
Keep in mind that firebird is case sensitive, so Tablename <>
TABLENAME <> tablename etc.To be more precise only quoted identifiers
are case sensitive, non quoted identifiers are not, and are
transformed to upper case.
Yes, that is pretty much what I gathered.  Thanks!