I have an SQL statement which is quite long. I want to declare a string
variable with this SQL statement and I want to have span multiple lines. I
could scrunch it all up and place it on a single line, but then the SQL
statement would be unreadable. There was a way to do this in VB, but how do
you do this is C#?
I want it to look something like this in the code.
string mySQL = "select 'Anchor' as Anchor_NonAnchor, combo.PROCESS_GROUP,
combo.COMBINATION, cf.CHARTFIELD,
grp.COMBO_DEFN_NAME, ' ' as Tree_Name, ' ' as
Node_Name,
cf.SEQUENCE_NBR_6, cval.SELECT_VALUE as Range_From,
' ' as
Range_To
from gapsc.ps_combo_grrul_tbl combo,
gapsc.ps_combo_rule_tbl Rul,
gapsc.ps_combo_group_tbl grp,
gapsc.ps_combo_cf_tbl cf,
gapsc.ps_combo_val_tbl cval
where Rul.EFFDT_TO = '2099-01-01'
and rul.combination = combo.combination
and grp.setid = rul.setid
and combo.setid = cf.setid
and rul.combination = cf.combination
and rul.combination = cval.combination
and grp.Process_Group = combo.Process_Group
and grp.combo_defn_name = rul.combo_Defn_Name
and cf.SETID = cval.SETID
and cf.COMBINATION = cval.COMBINATION
and cf.SEQUENCE_NBR_6 = cval.SEQUENCE_NBR_6
and cf.TREE_NAME = ' ' ";
Thanks in advance!!