Home » Developer & Programmer » Forms » problem to update record in tabular form (fom6i)  () 1 Vote
problem to update record in tabular form [message #359352] Sat, 15 November 2008 02:30 Go to next message
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 Go to previous messageGo to next message
Littlefoot
Messages: 20891
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 Go to previous messageGo to next message
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
  • Attachment: check_box.fmb
    (Size: 164.00KB, Downloaded 146 times)
Re: problem to update record in tabular form [message #359938 is a reply to message #359507] Tue, 18 November 2008 22:37 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Previous Topic: Stop the trigger's execution
Next Topic: Append Data
Goto Forum:
  


Current Time: Sat Dec 03 18:21:08 CST 2016

Total time taken to generate the page: 0.05220 seconds