Hi
How can I make the {if} directive span more lines in TUniQuery
The statements
UniQuery1.SQL.Add('SELECT * FROM Table1 WHERE'); UniQuery1.SQL.Add('{if MySQL'}');
UniQuery1.SQL.Add('Field1=0');
UniQuery1.SQL.Add('{else'}');
UniQuery1.SQL.Add('Field1=1');
UniQuery1.SQL.Add('{endif'}');
fails, but
UniQuery1.SQL.Add('SELECT * FROM Table1 WHERE'); UniQuery1.SQL.Add('{if MySQL'}field1=0{else}field1=1{endif}');
works well.
My SQL statements are way more complicated, so writing everything
in one line is annoying.
TIA Jens Lund