Skip name field and return the SQL command ?

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

Skip name field and return the SQL command ?

Postby luciano_f » 26.10.2016, 22:48

Personally I have googled but found nothing on the Internet how I can do this.
If anyone can help me I will be very grateful.

I've tried using the ZSQLProcessor most could not.

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

Select
NF.Documento,

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

From Nota_Fiscal NF


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