Data Retrievalhttp://www.orafaq.com/forum/./mv/msg/185779/574929/#msg_574929
what could be the cause of the following scenario :

A form is running, data is entered and saved. After saving on form, checking in the backend, the data is present. But when using the same form again to retrieve data, no data is shown.. and also if tried to enter same data (previously entered for saving again) then error comes up that data is already in the database.

could this be related to any restrictions that might be placed on tables or something ??

Thank you]]>vinxz2013-01-16T21:02:49-00:00Re: Data Retrievalhttp://www.orafaq.com/forum/./mv/msg/185779/574930/#msg_574930
Do you have a LIST_ITEM on the form?
]]>joy_division2013-01-16T21:53:10-00:00Re: Data Retrievalhttp://www.orafaq.com/forum/./mv/msg/185779/574931/#msg_574931
]]>vinxz2013-01-16T21:58:53-00:00Re: Data Retrievalhttp://www.orafaq.com/forum/./mv/msg/185779/574944/#msg_574944
vinxz

when using the same form again to retrieve data

How do you do that? By executing a query? If a block is a data block, then it *should* work OK.]]>Littlefoot2013-01-17T06:42:05-00:00Re: Data Retrievalhttp://www.orafaq.com/forum/./mv/msg/185779/575013/#msg_575013
The same table has other data that are present and retrieval via the same form. While inserting no error message appears so incoming traffic to DB is correct and therefore outgoing should be ok.

Im concerned if there can be restrictions placed on table somehow ??]]>vinxz2013-01-17T22:49:29-00:00Re: Data Retrievalhttp://www.orafaq.com/forum/./mv/msg/185779/575027/#msg_575027
On the other hand, did you put any WHERE condition to that data block? Is there any SET_BLOCK_PROPERTY that sets DEFAULT_WHERE (or ONETIME_WHERE) before executing a query?]]>Littlefoot2013-01-18T06:42:39-00:00