BUG: ODAC and QueryRecordCount fails if lastline is a commentline
Posted: Wed 21 May 2008 10:35
Hello,
oraQuery.SQL.text := 'select 'X' from dual';
oraQuery.SQL.Add('-- Comment in last line');
oraQuery.Options.QueryRecCount := true;
oraQuery.open; --> 'ORA:00907 : Missing right parenthesis'
This seems to be cause ODAC always adds the closing parenthesis
to the sqlstatement even if it is a commentline.
with regards
L.Bodes
oraQuery.SQL.text := 'select 'X' from dual';
oraQuery.SQL.Add('-- Comment in last line');
oraQuery.Options.QueryRecCount := true;
oraQuery.open; --> 'ORA:00907 : Missing right parenthesis'
This seems to be cause ODAC always adds the closing parenthesis
to the sqlstatement even if it is a commentline.
with regards
L.Bodes