Possible Bug in TOracleDataSet in RowId function

[W. Kroeker]

Hello,

there seem to be a bug, when you call the function "rowid" before a call of refresh and you have a call to a function in your query that raises an exception.
Reproduce: Create a simple form with delphi, put everything to query on the form. Put the statement

select to_date(:my_str_date, 'dd.mm.yyyy hh24:mi:ss') out_date from dual
union
select to_date(:my_str_date, 'dd.mm.yyyy hh24:mi:ss') + 1 out_date from dual

Set initial value of "my_str_date" to a valid value i.e. "01.01.2007 08:00:00", then activate the dataset.
Put a simple DBGrid on the form and connect it to the dataset.
Now put a button on the form that call SetVariable with an invalid value for the to_date function, then call "RowId", then call refresh (the dataset has allready to be active).
When you run the application go to the 2nd row in the grid then press the button.
You'll get an EListError Exception that hide the original Exception (invalid value for to_date...).
When you don't call "RowId" before refresh in the same case, then there is no problem.
If you want, I can send you a simple demo application that reproduces the problem.

This is an urgent problem in our application. Please help me asap.

Kind regards
W. Kroeker

 

[Marco Kalter]

I tried this, and get ORA-01861 as expected. Can you send me a little demo project to reproduce this?

 

[W. Kroeker]

I've sent the project to you. Please check.

 

[W. Kroeker]

Is there any progress on this topic?

 

[Marco Kalter]

Sorry, not yet. I will let you know.

 

[W. Kroeker]

Hi,
sorry for asking again, but we need to deliver a new version of our software to our customer. So we have to know when we can get a solution on this topic.
We wold like to tell our customer if he can get a solution on this topic yet. It's ok if it take some more time, but tell me please when do you think, to find a solution?

W. Kroeker

 

[Marco Kalter]

I will first need to investigate your demo project before I have any concrete information. Hopefully I can do so this week.

 

[W. Kroeker]

Still not found a solution?

Do you also sell/give the source code? Possibly we can help to debug and find a solution?

Regards
W. Kroeker

 

[Marco Kalter]

Unfortunately we did not yet have time for this. If you send me an e-mail, maybe we can work something out for the sourcecode/debugging.