RefreshRecord incorrect work

[DmitryV]

ODAC 9.3.9

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

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:

Code: Select all

SELECT ID AS "_3" FROM WITH LISTMAIN
WHERE
  ID = :ID

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?

[AlexP]

Hello,

Thank you for the information. We have reproduced the problem and will try to fix it as soon as possible

[DmitryV]

It would be good, thanks

[AlexP]

If you have any further questions, feel free to contact us.