Home » Developer & Programmer » Forms » DELETE INSERT A RECORD (FORM BUILDER 6i)
icon4.gif  DELETE INSERT A RECORD [message #354182] Thu, 16 October 2008 21:15 Go to next message
fadhzone
Messages: 61
Registered: April 2008
Member
HI All...
NO   PAYEE CD      PAYEE NAME    CHQ DATE   REF NO  DESC    AMOUNT  |
------------------------------------------------------------------- |
9999 XXXXX         XXXXXXXXXXXX  DD/MM/YYYY XXXXXX  XXXXX   9999.99 | 1ST BLOCK
9999 XXXXX         XXXXXXXXXXXX  DD/MM/YYYY XXXXXX  XXXXX   9999.99 | (1ST TABLE)
9999 XXXXX         XXXXXXXXXXXX  DD/MM/YYYY XXXXXX  XXXXX   9999.99 |
9999 XXXXX         XXXXXXXXXXXX  DD/MM/YYYY XXXXXX  XXXXX   9999.99 |

NO    ACCT CODE     ACCT DESC            DEBIT     CREDIT |
--------------------------------------------------------- |
9999  XXXX          XXXXXXXXXXXXXXXXX  9999.99    9999.99 | DISPLAY 
9999  XXXX          XXXXXXXXXXXXXXXXX  9999.99    9999.99 | BLOCK
9999  XXXX          XXXXXXXXXXXXXXXXX  9999.99    9999.99 |

NO    ACCT CODE     ACCT DESC            DEBIT     CREDIT |
--------------------------------------------------------- | HIDDEN
9999  XXXX          XXXXXXXXXXXXXXXXX  9999.99    9999.99 | BLOCK 
9999  XXXX          XXXXXXXXXXXXXXXXX  9999.99    9999.99 | (ACTUAL)
9999  XXXX          XXXXXXXXXXXXXXXXX  9999.99    9999.99 | (2ND TABLE)

The above is part of my form for entry acct data for particular payee..

During Add Mode / Correct Mode,User need to enter acct code.Then, the acct code info will be updated in hidden block.when user click payee cd,the acct info will be retrieve from hidden block into display block (the hidden block will store all acct info for all payee).

My problem is, when i retrieve the acct info,and make some changes,it will insert as new record into hidden block instead update it..i get the idea to make 'delete insert' way.

The question is how i'll gonna do that? Embarassed Embarassed Sad

[EDITED by LF: added [pre] tags]

[Updated on: Fri, 17 October 2008 01:17] by Moderator

Report message to a moderator

Re: DELETE INSERT A RECORD [message #354218 is a reply to message #354182] Fri, 17 October 2008 01:21 Go to previous messageGo to next message
Littlefoot
Messages: 20893
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I might be wrong, but this looks like a standard master-detail relationship. Would it help if you create such an "ordinary" form?

Because, this model seems to be a little bit ... complicated. Why do you use two "detail" blocks, one of them is hidden and the other one displayed? Why not using a single "second" block?
Re: DELETE INSERT A RECORD [message #354248 is a reply to message #354218] Fri, 17 October 2008 03:24 Go to previous messageGo to next message
fadhzone
Messages: 61
Registered: April 2008
Member
Yes seem like standard master-detail relation...

But...the user want like this...

"they can click payee code to view the account info during add/correct mode. so..each time they click the payee code, the data in 2nd block will change."
Re: DELETE INSERT A RECORD [message #354471 is a reply to message #354248] Sun, 19 October 2008 09:26 Go to previous message
Littlefoot
Messages: 20893
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
VIEWING account info should not modify anything. It is a read operation.

In order to display certain information, you could call another "account info") form or place this information onto another (stacked?) canvas or ...
Previous Topic: image save in blob column with oracle form6i in oracle10g
Next Topic: error commit
Goto Forum:
  


Current Time: Mon Dec 05 05:03:57 CST 2016

Total time taken to generate the page: 0.05323 seconds