Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

D6 & Ora 7.3.4 / SELECT with VARCHAR2(2000)

bockhopbockhop Member Posts: 6
HI there!

Problem is, using TQuery like
qry := TQuery.Create( nil );
qry.DatabaseName := 'ORA';
qry.SQL.Text := 'SELECT TITLE, COMMNT_LNG FROM COMMNTS WHERE KY = ' +
QuotedStr( 'M0014' );
qry.Open;
if qry.RecordCount = 1 then
begin
end;
qry.Close; // and Free ...

works fine if I eXclude COMMNT_LNG from Fields to be returned but
fails if it's done like above.
Fails means RecordCount returns -1 not even zero.

For a different table in this database also having a long field
doesn't fail at all.

Any hints??? Somehow urgent!

TIA, Tim

Sign In or Register to comment.