How can I capture the SQL code of a field ?

[luciano_f]

Hello I am giving a studied in your library and appears to be very powerful.
But I'm not able to use.

I use Firebird 2.5

I am looking to pass the name of the field and return all the SQL command using to generate the field.

If I have the following field:

Code: Select all

Coalesce(Case When (Trim(NF.N_CF) <> '') Then  NF.N_CF || ' ' End, '') 
 || 
Coalesce(Case When (Trim(NF.N_NFM) <> '') Then  NF.N_NFM || ' ' End, '') 
As CUPOM_NOTAFISCAL, 

If I pass this field "CUPOM_NOTAFISCAL"
I would like to return me

Code: Select all

Coalesce (Case When (Trim (NF.N_CF) <> '') Then NF.N_CF || '' End '')
  ||
Coalesce (Case When (Trim (NF.N_NFM) <> '') Then NF.N_NFM || '' End '')

How can I do this ?

Grateful.