setting property [message #399332] |
Tue, 21 April 2009 11:42 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
shahidmahmood2069
Messages: 11 Registered: February 2009
|
Junior Member |
|
|
Hi
I have name, add and city columns in tabular form in oracle developer. My query reterive 5 record. Name and add columns are not allowed for updated city is drop down list having six values by default(blank). When i reached last record
and press entered it goes to next record where no name and add exist. i want to stop the cursor not
to go there and stay on last record.
Also i want to set property disable of row where city is say 'NYK'
|
|
|
Re: setting property [message #399335 is a reply to message #399332] |
Tue, 21 April 2009 12:07 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
|
Use cursor for loop and write a Query to Exclude city Like 'NYK'
for Example
DECLARE
V_CITY VARCHAR2(10);
CURSOR C1 IS
SELECT CITY_CODE , CITY_NAME
FROM CITY WHERE CITY NOT LIKE 'NYK'
BEGIN
:MSG:=' ';
FOR C1_A IN C1
LOOP
GO_BLOCK('BLOCK_NAME');
-- FIRST_RECORD;
:CITY_CODE:=C1_A.CITY_CODE;
:CITY_NAME:=C1_A.CITY_NAME;
EXIT WHEN C1%NOTFOUND;
NEXT_RECORD;
END LOOP;
END;
You can use if then else for setting Visual attributes.
|
|
|
Re: setting property [message #399371 is a reply to message #399335] |
Tue, 21 April 2009 19:27 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
shahidmahmood2069
Messages: 11 Registered: February 2009
|
Junior Member |
|
|
Thanks for your reply. May be I have not expalined my problem well.
I fetch all records in tabular form with three columns and only city column can be updated through
drop down list. When i Press enter key after last record cursor goes to next row where no record exist
only city can be changed. I want to stop cursor not to go after last record. Also if in city 'NYK'
exit no one can change this record.
|
|
|
|
Re: setting property [message #399445 is a reply to message #399385] |
Wed, 22 April 2009 04:40 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
shahidmahmood2069
Messages: 11 Registered: February 2009
|
Junior Member |
|
|
How I can disable on row when my form is in tabular form i.e if city = 'NYK' then disable that row.
I used set item instance property at form level and also at post query but it does not work
|
|
|
|
|
Re: setting property [message #399631 is a reply to message #399446] |
Thu, 23 April 2009 03:44 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
danish_fsd@yahoo.com
Messages: 38 Registered: February 2008 Location: Pakistan
|
Member |
|
|
As I know, you can't disable a single row in detail block. So, you need to change your logic.
For instance, you may create two blocks and restrict one block to city = 'NYK' in block's where condition property and restrict other block for other city values.
Regards
Danish
|
|
|