Subject Re: [firebird-support] In Firebird what table contains the email address?
Author Helen Borrie
At 05:42 AM 27/04/2012, kissthegirlsandmakethemcry wrote:
>In Firebird what table contains the email address?
>I'm currently do a select statement, but I can't seem to find the email address.
>Here is my current select statement:
>SELECT, so.num AS sonumber, so.customercontact, so.shiptoname, so.shiptoaddress, so.shiptocity, so.cost, stateconst.code, so.shiptozip, countryconst.abbreviation,,carrier.description,shipcarton.freightweight, as shipcartionid, shipcarton.cartonnum, customercontactview.contactnum FROM so
>LEFT JOIN countryconst ON so.shiptocountryid =
>LEFT JOIN stateconst ON
>LEFT JOIN carrier ON so.carrierid =
>LEFT JOIN shipcarton ON = shipcarton.orderid
>LEFT JOIN customercontactview ON so.customerid=customercontactview.custid

A query does not return fields that are not specified.

>I've looked in various tables and cannot seem to find it.
>Any help would be greatly appreciated!!

Guessing that the column name contains the character string "EMAIL", you could try this (in isql or another query tool):

select r.rdb$relation_name, rf.rdb$field_name
from rdb$relations r
join rdb$relation_fields rf
on r.rdb$relation_name = rf.rdb$relation_name
where rf.rdb$field_name containing 'EMAIL'

Other than that, find the person who designed the database and punch his/her nose for not leaving a data dictionary for future generations! ;-)