OraFAQ Forum: Forms » DELETE INSERT A RECORD

Home » Developer & Programmer » Forms » DELETE INSERT A RECORD (FORM BUILDER 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DELETE INSERT A RECORD [message #354182]

Thu, 16 October 2008 21:15

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

[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

Littlefoot
Messages: 21823
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?

Report message to a moderator

Re: DELETE INSERT A RECORD [message #354248 is a reply to message #354218]

Fri, 17 October 2008 03:24

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."

Report message to a moderator

Re: DELETE INSERT A RECORD [message #354471 is a reply to message #354248]

Sun, 19 October 2008 09:26

Littlefoot
Messages: 21823
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 ...

Report message to a moderator

Previous Topic:	image save in blob column with oracle form6i in oracle10g
Next Topic:	error commit

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 10 01:11:56 CST 2025