How can I capture the SQL code of a field ?

The official tester's forum for ZeosLib 7.1. Ask for help, post proposals or solutions.
luciano_f
Fresh Boarder
Fresh Boarder
Posts: 2
Joined: 26.10.2016, 22:40

How can I capture the SQL code of a field ?

Postby luciano_f » 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:

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.

Return to “ZeosLib 7.1 stable Forum”

Who is online

Users browsing this forum: No registered users and 1 guest