Home » Developer & Programmer » Forms » Data not enter to table
Data not enter to table [message #132724] Mon, 15 August 2005 20:38 Go to next message
swchen
Messages: 15
Registered: July 2005
Location: malaysia
Junior Member
Hi to all at here.

Me swchen again, me got some problem again..i find out my program when i press the save button and save the new record successfully at oracle form but when i go to checking at database table. I cant find out the record data i entered before. May i know what happened to my program? Or anyone at here have this experience before.
Re: Data not enter to table [message #132726 is a reply to message #132724] Mon, 15 August 2005 20:44 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
The missing data ... is it in a table associated with a block or is it in a table that you have used an 'insert' or 'update' statement to 'move' your data?

David

[Updated on: Mon, 15 August 2005 20:45]

Report message to a moderator

Re: Data not enter to table [message #132728 is a reply to message #132726] Mon, 15 August 2005 20:54 Go to previous messageGo to next message
swchen
Messages: 15
Registered: July 2005
Location: malaysia
Junior Member
No..so what sugguest Mr.David you can give me??
Re: Data not enter to table [message #132730 is a reply to message #132728] Mon, 15 August 2005 21:01 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
No which?? 'No' - it is not a table associated with a block or 'No' - it is not a table populated manually?

My suggestion is to answer my questions, in order, and fully.

David
Re: Data not enter to table [message #132731 is a reply to message #132730] Mon, 15 August 2005 21:11 Go to previous messageGo to next message
swchen
Messages: 15
Registered: July 2005
Location: malaysia
Junior Member
Sorry...my answer means i din use the statment like insert or update...
Re: Data not enter to table [message #132732 is a reply to message #132731] Mon, 15 August 2005 21:20 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Sorry for being 'snappy' ... but I am a bit 'pressed' at work today.

Do you have your own 'key-commit' triggers? If so, make sure that you DO have a 'commit' somewhere in it. If you do have a 'commit', try changing it to 'standard.commit' and see if that fixes your problem.

Make sure that you have not defined your fields, in your block, as being 'query only'. If you do then any new data will not be saved.

David
Re: Data not enter to table [message #132735 is a reply to message #132732] Mon, 15 August 2005 22:10 Go to previous message
swchen
Messages: 15
Registered: July 2005
Location: malaysia
Junior Member
Thanks for answering my question..Thanks so much....be happy and have nice day...
Previous Topic: Oracle AppServer 10g (10.1.3) Developer Preview 4
Next Topic: Problem with trigger.
Goto Forum:
  


Current Time: Fri Sep 20 01:56:57 CDT 2024