OraFAQ Forum: Forms » Cursor record

Home » Developer & Programmer » Forms » Cursor record (orcale form 10g)

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

Cursor record [message #483307]

Fri, 19 November 2010 22:55

swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai

Senior Member

Hi i have multi data block filed. and checkbox field which based on control block

My task is when i check checkbox only one field should enabled and my mouse goes to that field

e.g

item11 item21 item31 chkbox1
item12 item22 item32 chkbox2

Scenario like this :

My item field based on data block and checkbox based on control block,
while i checked chkbox1 , only item31 on that current record should be enabled and i changed value only on that field

second scenario is when i checked chkbox1 , my cursor goes to item31...not item32

Report message to a moderator

Re: Cursor record [message #483316 is a reply to message #483307]

Sat, 20 November 2010 03:49

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

Shouldn't the checkbox be in the same datablock as everything else?

Report message to a moderator

Re: Cursor record [message #483323 is a reply to message #483316]

Sat, 20 November 2010 04:51

swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai

Senior Member

yes....checkbox is not placed in same data block

Report message to a moderator

Re: Cursor record [message #483331 is a reply to message #483323]

Sat, 20 November 2010 08:06

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Why don't you directly click ITEM31 (i.e. no checkboxes at all)?

Report message to a moderator

Re: Cursor record [message #483345 is a reply to message #483331]

Sat, 20 November 2010 16:21

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

Or put the checkbox in the same block as the items you want it to effect. What is the purpose of having it in a different block?

Report message to a moderator

Re: Cursor record [message #483408 is a reply to message #483345]

Sun, 21 November 2010 22:41

swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai

Senior Member

yes, You are right...i placed my checkbox in same datablock...

Report message to a moderator

Re: Cursor record [message #483436 is a reply to message #483408]

Mon, 22 November 2010 02:33

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

So is the problem fixed now?

Report message to a moderator

Re: Cursor record [message #483443 is a reply to message #483436]

Mon, 22 November 2010 04:18

swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai

Senior Member

No my prblem is
when i checked checkbox ,i want to enanable item31 only...not item32..

which trigger i used for this

Report message to a moderator

Re: Cursor record [message #483444 is a reply to message #483443]

Mon, 22 November 2010 04:24

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

WHEN-CHECKBOX-CHANGED (with SET_ITEM_INSTANCE_PROPERTY built-in).

[Updated on: Mon, 22 November 2010 04:25]

Report message to a moderator

Re: Cursor record [message #483445 is a reply to message #483444]

Mon, 22 November 2010 04:26

swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai

Senior Member

I write Code on that trigger but when
i click checkbox = 'Y' it enbaled my both item31 & item 32..

i want to set that field at record level..
can u give me a code please

Report message to a moderator

Re: Cursor record [message #483446 is a reply to message #483445]

Mon, 22 November 2010 04:30

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I said almost everything I wanted to say at the moment. I mentioned both trigger and built-in you should use to do that. Now it is your turn to study documentation and apply what you've learnt. Then, if it still doesn't work, post code you managed to write and someone will take a look.

Report message to a moderator

Re: Cursor record [message #483448 is a reply to message #483446]

Mon, 22 November 2010 04:35

swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai

Senior Member

Thanks you...
i write code thsi way
IF :jou_tra1_tab.ck_amt = 'Y' THEN
set_item_instance_property( 'jou_tra1_tab.jtt_amt_1',CURRENT_RECORD,UPDATE_ALLOWED, property_true);

but it still not work , at record level
it work on data block level

Report message to a moderator

Re: Cursor record [message #483450 is a reply to message #483448]

Mon, 22 November 2010 04:39

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

Rubbish!

That has to work at record level. The only way it can affect the entire block is if you run that code in a loop that loops over every record.

Report message to a moderator

Previous Topic:	i need a doc or pdf to explain how to use OLE2
Next Topic:	how 2 share PL/SQL variable between 2 forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 17:15:39 CDT 2024