Zum Hauptinhalt gehen

Suche

Suche

How To Set Field Alias In Bartender

Kommentare

1 Kommentar

  • Avatar
    Shotaro Ito

    Below worked, so concatenation of field is fine.

    SELECT ("NAME" + "CODE") AS "f1" FROM "S1"."DATA" WHERE "CODE"='?Q1'
    

    So not sure the reason of the error - Alias "Description" already used in the query - could it be AS "Description1_2" etc?

     

    Bartender's text / barcode object can have 2 or more data sources, so usually you don't need to concatenate fields in SQL.

    Though you have option to use Custom SQL, try to avoid using Custom SQL. If that's can be done by creating view in SQL server, that's better connect to the view from BarTender.

    0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.