Steps to reproduce:
1. Create a table.
Code: Select all
CREATE TABLE TEST (FIELD1 VARCHAR2(40), FIELD2 CLOB)3. Write SELECT * FROM TEST into SQL-property.
4. Create persitent fields (OraQuery1FIELD1, OraQuery1FIELD2)
5. Create Button1Click
Code: Select all
procedure TForm1.Button1Click(Sender: TObject);
begin
if OraQuery1FIELD1.AsString = '' then ShowMessage('Field 1 Empty'); // works
if OraQuery1FIELD2.AsString = '' then ShowMessage('Field 2 Empty'); // exception
end;