SQL Query failure

David Paras

• April 10, 2013 21:31

Can you take a look at this query why it is failing , is the syntax not correct ?

String schemaQuery = "select distinct tss.nopiece \"SALES_ID\", tss.DEBUTSERIE \"SERIES_START\" , tss.FINSERIE \"SERIES_END\" , \'11111111111111\' CLIENT_OID , \'ADEPTIA\' CLIENT_NAME, tdo.OIDDEPOT \"DEPOT_OID\", tss.UPDDATE \"DATE_SALES\", tss.UPDUSER \"USER_SALES\" ,tpc.OIDPRODUIT \"PRODUCT_OID\", tss.qteliv \"VOUCHER_QUANTITY\",\'MGA\' CURRENCY from

$$schemaName$$.TTSL_SERIESORTIE tss ,

$$schemaName$$.TDETAILOPERATION tdo ,

$$schemaName$$.TPRODUITCOMMERCIAL tpc,

$$schemaName$$.TSITECOMMERCIALE tsc

where

tss.OIDDETAILOPERATIONDIVERSE=tdo.OIDORIGINELIVRAISON

and tdo.OIDDEPOT=tsc.OID

and tss.OIDPRODUITLIVRE = tpc.OIDPRODUITLIVRE

and tss.OID='$$OID$$'";

0

• 

  David Paras

  • April 10, 2013 21:31

  The query you are using is a SQL select query and it can contain only column names not column values.

  0

Post is closed for comments.