Home » Developer & Programmer » Forms » Display item in forms
Display item in forms [message #273489] Wed, 10 October 2007 11:23 Go to next message
mnanias
Messages: 40
Registered: September 2007
Location: AMERICA
Member
Hi,
I have to create a form which displays columns on a particular table so by using wizard i tried to create and i was success but now i have to just display those and no one can modify,insert or delete those they can only view,so now when i try use display item in property pallet of those columns I am not able to display any of the data or rows.So wat u want me to do my task is to just display the columns and the rows in a table wer those cant be changed or deleted any of the DML or DDL operations shouldn't be done.

Thank you in advance.
Re: Display item in forms [message #273608 is a reply to message #273489] Thu, 11 October 2007 01:26 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Change the properties of your block so that 'insert', 'update', and 'delete' have been set to 'no' (or 'off' - whatever).

David
Re: Display item in forms [message #273636 is a reply to message #273489] Thu, 11 October 2007 02:52 Go to previous messageGo to next message
chaudharyshamraiz
Messages: 4
Registered: May 2007
Location: Pakistan
Junior Member

go to propertity palate of ur datablock
and set the following properities
update allowed = no
insert allowed = no
delect allowed = no
Re: Display item in forms [message #273705 is a reply to message #273636] Thu, 11 October 2007 07:55 Go to previous messageGo to next message
mnanias
Messages: 40
Registered: September 2007
Location: AMERICA
Member
Hi,
I have done that,I have changed the property settings but the problem is i have a cancel button on my screen and when i do cancel i should exit the form but after changing the property of the text boxes when i do cancel an alert msg poped up asking "do u want to save the changes" wer i haven't done any changes so i don't want that window to be poped up,can u help me in this.

Thank You
Re: Display item in forms [message #273711 is a reply to message #273489] Thu, 11 October 2007 08:12 Go to previous messageGo to next message
scorpio_biker
Messages: 154
Registered: November 2005
Location: Kent, England
Senior Member
You can do an EXIT_FORM(NO_VALIDATE) which will discard any changes made to the form and won't generate the pop-up.
Re: Display item in forms [message #273718 is a reply to message #273711] Thu, 11 October 2007 08:42 Go to previous messageGo to next message
mnanias
Messages: 40
Registered: September 2007
Location: AMERICA
Member
Hi,
It worked Thank You.
Re: Display item in forms [message #273863 is a reply to message #273718] Fri, 12 October 2007 01:10 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
If the user has not changed any values and you get that message then your CODE must be changing something, probably in a post_query trigger. Leaving this code active is, in my opinion, dangerous. Find out which database field you are modifying in your code and decide whether this is correct behaviour.

David
Re: Display item in forms [message #273975 is a reply to message #273863] Fri, 12 October 2007 08:26 Go to previous messageGo to next message
mnanias
Messages: 40
Registered: September 2007
Location: AMERICA
Member
Hi,
Ok then there is only on textbox should be changed and that is in the header_block ,I have three blocks 1)header_block 2)record_block 3)switchboard so now the records in record_block shouldn't be changed and they cant be modified there is a text box in header_block which can be changed and i have a cancel button on my switchboard so wat exactly u want me to do please explain me .I use to get pop up saying " do u want the changes to be saved" and by using ur command now i got rid of that but as u said i have one text box which should be changed and it should ask for save when the text box is changed so wat is the solution for this.

Thank You
Re: Display item in forms [message #274169 is a reply to message #273975] Sun, 14 October 2007 21:20 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Search your code for an assignment statement that places data into a database field. Review whether this code is valid.

David
Previous Topic: Connection to Oracle 9i from forms 6
Next Topic: Help: Need to set Update Allowed property
Goto Forum:
  


Current Time: Mon Dec 05 15:03:42 CST 2016

Total time taken to generate the page: 0.04991 seconds