I get exception when I try to query a view which has calls to Access functions like IIf.
Here is an example of such a view:
view1: SELECT t1.*, IIf(id>1,'more than 1','less or equal 1') AS iif_col FROM t1;
When I execute query:
SELECT * FROM view1;
HXTT ACCESS throws this:
java.sql.SQLException: view1 is a stored procedure, not a view
Error Code:147456
SQL State:24000
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.sql.access.ae.a(Unknown Source)
Though there is no problem if I execute the query from which view1 was created.
I've uploaded database to you ftp server as viewtest.mdb
Any suggestions?
Thanks in advance,
Nikita
|
>SELECT t1.*, IIf(id>1,'more than 1','less or equal 1') AS iif_col FROM t1;
Because you're using ", not ' to separate string value in MS Access.
|
The next package will detect and parse those " as ' for sql standard.
|