Home » Developer & Programmer » Forms » list problem ( urgently need )
list problem ( urgently need ) [message #223104] Wed, 07 March 2007 09:56 Go to next message
rajat_chaudhary
Messages: 141
Registered: November 2006
Location: india
Senior Member

hi everyone,
actually i made a form in which i introduced a list item ,where i want a functionality which has to be done by list and that is


right now in my form i insert a value through list and then save that record ,now the value is shown in list and the value is stored in database also.... ( this has to done by a "insert button") ..........
and in the same form i a "delete button" also to delete a record corresponding the value in list .......

please try the attached module and repeat the procedure two or three times continuously and then see the problem
again run the form after insert a record through list item ,it does not show the recently inserted value...... and after repeating the procedure second or third time ,forms runtime denied to update/insert .......

please give the solution as soon as possible ..
if possible then please attach a modified module.......(need it very urgently )
  • Attachment: list.fmb
    (Size: 52.00KB, Downloaded 233 times)

[Updated on: Wed, 07 March 2007 11:01]

Report message to a moderator

Re: list problem ( urgently need ) [message #224025 is a reply to message #223104] Mon, 12 March 2007 12:37 Go to previous messageGo to next message
rajat_chaudhary
Messages: 141
Registered: November 2006
Location: india
Senior Member

why no one replying for this question......
Re: list problem ( urgently need ) [message #225436 is a reply to message #224025] Mon, 19 March 2007 23:30 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Re: list problem ( urgently need ) [message #225647 is a reply to message #225436] Tue, 20 March 2007 13:00 Go to previous messageGo to next message
rajat_chaudhary
Messages: 141
Registered: November 2006
Location: india
Senior Member

no still not.....
Re: list problem ( urgently need ) [message #225898 is a reply to message #225647] Wed, 21 March 2007 20:04 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
This is a 'login' form. Please search this forum for 'login'.

Normally we would expect that you supply the table definitions along with your form so that we can run it.

I looked at the file and you have code like
  UPDATE LOGON
  SET PASSWORD = :LOGON.PASSWORD
  WHERE USER_NAME = :LOGON.USER_NAME;
  COMMIT_FORM;
and
  DELETE LOGON
  WHERE USER_NAME = :LOGON.USER_NAME;
  COMMIT_FORM;


The 'commit_form' command only performs a 'commit' in the database if the form 'knows' that it has changed something in the database. Your 'update' and 'delete' commands are performed directly into the database and the form has no idea whether anything has been changed.

Please search this forum for 'standard.commit' and read some of the threads concerning this command (look at the older ones for fuller explanations). Also, in the Forms Builder, look at the 'Built-in Packages' node and you will see 'Standard' is listed there.

David
Re: list problem ( urgently need ) [message #226010 is a reply to message #225898] Thu, 22 March 2007 05:00 Go to previous messageGo to next message
bhupinderbs
Messages: 67
Registered: July 2006
Location: Bangalore
Member
Hi!!
Here is solution to user LIST problem.
I have just changed table name from LOGON to LOGON_LIST.
One more thing, you are using PASSWORD column, again it is reserve word.

Be very carefull using reserve words.

Hope this will solve your problem.


Bhupinder Singh
  • Attachment: LIST_NEW.fmb
    (Size: 68.00KB, Downloaded 218 times)
Re: list problem ( urgently need ) [message #226145 is a reply to message #226010] Thu, 22 March 2007 11:55 Go to previous messageGo to next message
rajat_chaudhary
Messages: 141
Registered: November 2006
Location: india
Senior Member

thanks bhupinder , thanks vey much.
u help me at the time when i required it very urgently.
can i got ur mail-id on which i can send my queries and get an immediate and good answer. might be that u don't have any problem.
and if possible then we have chat also......
if u want....
BY THE WAY AGAIN THANKS.....
BYE AND TAKE CARE........
RAJAT CHAUDHARY
Re: list problem ( urgently need ) [message #241942 is a reply to message #223104] Thu, 31 May 2007 02:30 Go to previous messageGo to next message
lakshmi surya ram
Messages: 188
Registered: June 2006
Location: HYDERABAD
Senior Member

hi folks ,
I was not able to view the code in the posted fmbs.
can you pls guide me in this staff?
thanks,
Surya
Re: list problem ( urgently need ) [message #241965 is a reply to message #223104] Thu, 31 May 2007 04:07 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

Maybe you are using lower version of form builder...
Re: list problem ( urgently need ) [message #241979 is a reply to message #241965] Thu, 31 May 2007 05:04 Go to previous messageGo to next message
lakshmi surya ram
Messages: 188
Registered: June 2006
Location: HYDERABAD
Senior Member

Hi,
I am using oracle 6i.
is it that low version for not supporting?
thanks,
Surya
Re: list problem ( urgently need ) [message #242116 is a reply to message #241979] Thu, 31 May 2007 12:52 Go to previous messageGo to next message
rajat_chaudhary
Messages: 141
Registered: November 2006
Location: india
Senior Member

HI lakshmi surya ram,
NO IT'S NOT LIKE THAT
Re: list problem ( urgently need ) [message #242170 is a reply to message #223104] Thu, 31 May 2007 19:06 Go to previous message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

on my part it's like that. I can't see program unit built in ^i if i'm using ver.5. However, I open this file with 6i and PU does not show. Try to use 9i. I don't know if there's other issue for this problem.
Previous Topic: Commit button
Next Topic: Form Builder : interface language
Goto Forum:
  


Current Time: Sat Dec 03 18:25:53 CST 2016

Total time taken to generate the page: 0.07781 seconds