Edition: 3.0.0.3
//MS SQL
UniQuery1.Close;
UniQuery1.SQL.Clear;
UniQuery1.Conncection:= MSconn;
UniQuery1.SQL.Add('if exists(select * from table1)');
UniQuery1.SQL.Add(' select 1 as iBS');
UniQuery1.SQL.Add('else');
UniQuery1.SQL.Add(' select 0 as iBS');
UniQuery1.Open; //It's OK
//ASE
UniQuery1.Close;
UniQuery1.SQL.Clear;
UniQuery1.Conncection:= ASEconn;
UniQuery1.SQL.Add('if exists(select * from table1)');
UniQuery1.SQL.Add(' select 1 as iBS');
UniQuery1.SQL.Add('else');
UniQuery1.SQL.Add(' select 0 as iBS');
UniQuery1.Open; //error message "SQL statement doesn't return rows"
________
LEXUS LX HISTORY
SQL statement doesn't return rows
SQL statement doesn't return rows
Last edited by cxg417 on Tue 15 Feb 2011 14:59, edited 1 time in total.