| problem to update record in tabular form [message #359352] |
Sat, 15 November 2008 02:30  |
kvsd_12
Messages: 5
Registered: July 2008
|
Junior Member |
|
|
hi
i have create a tabular form which have parameter .that paramaeter checks condition and fetch record. but some of the column if updated after running form then all record save in the databae(means those displayed on that tabular form )
so, my problem is i want only save those record which i had update only those record.
please help me immediatly its live problem....
|
|
|
|
| Re: problem to update record in tabular form [message #359408 is a reply to message #359352] |
Sat, 15 November 2008 13:17  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
If I understood you correctly, this is NOT a data block, but control block, which get populated manually. Right? Then you update certain items in several records, press a button and want to save (save? Insert or update?) only changed records.
If so, how do you do that? Looping through all block records? In that case, you'll have to create additional item (a checkbox, for example) which will indicate modified records so that they could be recognized.
However, why don't you use an ordinary data block? It would save you a lot of time and effort. If you didn't know, a "parameter value" you have mentioned, which decides which records are to be fetched, can be used in the DEFAULT_WHERE block's property (and can be set by the SET_BLOCK_PROPERTY built-in).
Although, I may be completely wrong, failing to understand the question.
|
|
|
|
| Re: problem to update record in tabular form [message #359507 is a reply to message #359408] |
Mon, 17 November 2008 00:06 |
kvsd_12
Messages: 5
Registered: July 2008
|
Junior Member |
|
|
thanks for reply
but u don't understand my problem.
i have two block first one created by custom table and second one used for mentioned parameter so it can check condition and fetch records from database to form i m sending attachment so u cleared problem
|
|
|
|
| Re: problem to update record in tabular form [message #359938 is a reply to message #359507] |
Tue, 18 November 2008 22:37 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
| Sent by"Report message to a moderator" | its very argent to me please reply me, i m facing a big problem to resolve this problem
|
Do NOT use use "Report messege to a moderator" for anything other than inappropriate usage or language, or asking for an entry to be deleted or moved.
The other members of the forum will get to your request sometime. Just because it is urgent to you, does not make it urgent to other people.
David
[EDITED by DJM: fixed typos]
[Updated on: Tue, 18 November 2008 22:40] Report message to a moderator |
|
|
|
| Re: problem to update record in tabular form [message #359939 is a reply to message #359507] |
Tue, 18 November 2008 22:44 |
|
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Just use the standard features of Oracle Forms, use the items of the 'parameters' block in the 'default_where' of your data block and Forms will handle the saving of modified records for you.
Do not try to program Oracle Forms as you would VB. Just use the default behaviour and make as few changes as are absolutely necessary.
David
|
|
|
|
) 1 Vote
] 
Blog
Search
Help
Members
Register
Login
Home
