| Data Retrieval [message #574929] |
Wed, 16 January 2013 15:02  |
 |
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 #575027 is a reply to message #575013] |
Fri, 18 January 2013 00:42  |
 |
Littlefoot
Messages: 21807
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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
