How can I capture the SQL code of a field ?
Posted: 27.10.2016, 18:41
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:
If I pass this field "CUPOM_NOTAFISCAL"
I would like to return me
How can I do this ?
Grateful.
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, 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 '')Grateful.