Performing Select and delete on User Tables

[sudipta]

Hi,

I am new to Progress.

I am trying to execute the following statements from SQL Explorer:

set schema 'arijit';
select * from arijit.ReceiptHeads;
delete from arijit.ReceiptHeads;

The output is as follows:

=== Statement 1. ===
set schema 'arijit';

=== Statement 2. ===
select * from arijit.ReceiptHeads;
=== SQL Exception 1 ===
SQLState=42S02
ErrorCode=-20005
[JDBC Progress Driver]:Table/View/Synonym not found (7519)
Errors 1.
=== Statement 3. ===
delete from arijit.ReceiptHeads;
=== SQL Exception 1 ===
SQLState=42S02
ErrorCode=-20005
[JDBC Progress Driver]:Table/View/Synonym not found (7519)
Errors 1.
Statements: 3; Updates 0; Rows 0; Errors: 2; Warnings: 0. (8926)

The tables are accesible when check using the Data Dictionary Tool.

Please someone guide.

 

[tamhas]

See response on the DB forum. You really should only post it one place. SQL would have been the right one in this case.