D6 & Ora 7.3.4 / SELECT with VARCHAR2(2000)

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.

Howdy, Stranger!

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

Categories