RefreshRecord incorrect work
Posted: Wed 25 Jun 2014 04:17
ODAC 9.3.9
My OraQuery.SQL like
InsertSQL, UpdateSQL, DeleteSQL written manually, RefreshSQL and RecCountSQL is blank. In OraQueryEditor, on page "SQL Generator", TableName combobox value automatically determined as "WITH" string, not my table "TechTable".
When I call RefreshRecord method, I get an error ORA-00903. Really, SQL Monitor shows a query that is called at this point, here:
What is it, first? 
Otherwise, when I manualy set TableName combo value "MY_SCHEMA.TechTable", when query open I get an error "Unknown table MY_SCHEMA.TechTable", although, in the other case (as above) and everything works - all grants exists.
In previous ODAC versions (except for the last few) all worked fine (and TableName value on SQL Generator page was empty).
How to solve it now?
My OraQuery.SQL like
Code: Select all
SELECT lst.*, COUNT(*) OVER() as CNT
FROM
(
WITH ListMain AS
( -- This is base query
SELECT * FROM TechTable
)
/*
here optional select statememt
*/
SELECT *
FROM ListMain
WHERE Id = Id_Orig
) lst
When I call RefreshRecord method, I get an error ORA-00903. Really, SQL Monitor shows a query that is called at this point, here:
Code: Select all
SELECT ID AS "_3" FROM WITH LISTMAIN
WHERE
ID = :IDOtherwise, when I manualy set TableName combo value "MY_SCHEMA.TechTable", when query open I get an error "Unknown table MY_SCHEMA.TechTable", although, in the other case (as above) and everything works - all grants exists.
In previous ODAC versions (except for the last few) all worked fine (and TableName value on SQL Generator page was empty).
How to solve it now?