Home » Developer & Programmer » Forms » Data Retrieval (Oracle 10g)
Data Retrieval [message #574929] Wed, 16 January 2013 15:02 Go to next message
vinxz
Messages: 4
Registered: January 2013
Location: Fiji
Junior Member
Hi

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
Re: Data Retrieval [message #574930 is a reply to message #574929] Wed, 16 January 2013 15:53 Go to previous messageGo to next message
joy_division
Messages: 4546
Registered: February 2005
Location: East Coast USA
Senior Member
How are you "retrieving" it?

Do you have a LIST_ITEM on the form?
Re: Data Retrieval [message #574931 is a reply to message #574930] Wed, 16 January 2013 15:58 Go to previous messageGo to next message
vinxz
Messages: 4
Registered: January 2013
Location: Fiji
Junior Member
Its using Text_Item to retrieve data on...

Re: Data Retrieval [message #574944 is a reply to message #574931] Thu, 17 January 2013 00:42 Go to previous messageGo to next message
Littlefoot
Messages: 19816
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What is that block's source? Is it a data block?

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.
Re: Data Retrieval [message #575013 is a reply to message #574944] Thu, 17 January 2013 16:49 Go to previous messageGo to next message
vinxz
Messages: 4
Registered: January 2013
Location: Fiji
Junior Member
Yes it is a data block, referencing to table from database.

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 ??
Re: Data Retrieval [message #575027 is a reply to message #575013] Fri, 18 January 2013 00:42 Go to previous message
Littlefoot
Messages: 19816
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Restriction on a table? I can't think of any that would prevent you from selecting existing data from it, directly. If there was a view (with a WHERE clause) and if data block was created on that view, then yes - that would be possible.

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?
Previous Topic: Selected value in lov should not dispalyed agin in lov.
Next Topic: use like operator with if condition
Goto Forum:
  


Current Time: Thu Nov 27 12:51:45 CST 2014

Total time taken to generate the page: 0.15671 seconds