How to make sure a field is retrieved from a view
Posted: Tue 16 Jun 2009 13:59
Hello
On the server we have a stored procedure for update like this
SELECT ID
INTO v_id
FROM am_kurvereg.kurvereg
WHERE
ID = pi_id
AND edit_date = pi_edit_date;
UPDATE am_kurvereg.kurvereg
SET strkafs = pi_strkafs
WHERE ID = pi_id;
EXCEPTION
WHEN NO_DATA_FOUND THEN RAISE am_def.pkg_fejl.err_dirty;
This is the scheme we are using for Optimistic update.
The edit_date field is updated by a trigger.
In DotNet the first edit goes fine, but when I refresh the grid or call select again, the edit_date field is not retrieved.
Is there any way to make sure that a field is always retrieved - bypassing the cache ?
Best regards
Glenn
On the server we have a stored procedure for update like this
SELECT ID
INTO v_id
FROM am_kurvereg.kurvereg
WHERE
ID = pi_id
AND edit_date = pi_edit_date;
UPDATE am_kurvereg.kurvereg
SET strkafs = pi_strkafs
WHERE ID = pi_id;
EXCEPTION
WHEN NO_DATA_FOUND THEN RAISE am_def.pkg_fejl.err_dirty;
This is the scheme we are using for Optimistic update.
The edit_date field is updated by a trigger.
In DotNet the first edit goes fine, but when I refresh the grid or call select again, the edit_date field is not retrieved.
Is there any way to make sure that a field is always retrieved - bypassing the cache ?
Best regards
Glenn