OraFAQ Forum: Forms » database not updating

Home » Developer & Programmer » Forms » database not updating (oracle 10g)

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

database not updating [message #392036]

Mon, 16 March 2009 02:34

leumas
Messages: 22
Registered: March 2009
Location: philippines

Junior Member

I created a form that has 2 tables the problem is that when i run the form. it updates the first table but the 2nd table remains empty. what could be the possible problems?

Report message to a moderator

Re: database not updating [message #392062 is a reply to message #392036]

Mon, 16 March 2009 04:20

jolly_makkar
Messages: 63
Registered: March 2008

Member

Does the table have relation among them?
Test by saving both blocks manually ...Use push button

Report message to a moderator

Re: database not updating [message #392069 is a reply to message #392036]

Mon, 16 March 2009 04:45

leumas
Messages: 22
Registered: March 2009
Location: philippines

Junior Member

yes. I have checked the relation of the database and I don't see anything wrong with the tables. oracle also does not display any error when saving. It shows that the items where saved and yet the database is empty.

Report message to a moderator

Re: database not updating [message #392071 is a reply to message #392069]

Mon, 16 March 2009 04:51

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

Senior Member
Account Moderator

Are you working on the same schema in both cases (Forms and SQL*Plus)? I mean, perhaps you have modified a table in one schema using Forms, and viewing what has happened in another schema using SQL*Plus (or another tool) (in another database).

What happens if you execute query in the detail block (leave the master "as is")?

Report message to a moderator

Re: database not updating [message #392074 is a reply to message #392036]

Mon, 16 March 2009 05:02

leumas
Messages: 22
Registered: March 2009
Location: philippines

Junior Member

I checked the schema. I am running the same schema. I'm not sure how to query the detail.

Report message to a moderator

Re: database not updating [message #392075 is a reply to message #392074]

Mon, 16 March 2009 05:04

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

Senior Member
Account Moderator

Go to the detail block and EXECUTE QUERY.

Report message to a moderator

Re: database not updating [message #392184 is a reply to message #392036]

Mon, 16 March 2009 22:57

leumas
Messages: 22
Registered: March 2009
Location: philippines

Junior Member

nothing happens when query the detail block. the cursor moves to the next item.

Report message to a moderator

Re: database not updating [message #392217 is a reply to message #392184]

Tue, 17 March 2009 01:24

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

Senior Member
Account Moderator

Executing a query moves focus to the next item?!?

It appears that there's something wrong about your form. Perhaps you should delete it and create a brand new one. Use wizard to help you create both master and detail block, along with the relation between them. By default, Forms will correctly maintain master-detail relationship and make sure that changes you make are saved into the database.

Once you make it work, try to make it fancy (i.e. add your own functionalities).

Report message to a moderator

Re: database not updating [message #392248 is a reply to message #392036]

Tue, 17 March 2009 03:12

leumas
Messages: 22
Registered: March 2009
Location: philippines

Junior Member

thanks.

Report message to a moderator

Previous Topic:	Mandatory Field problem
Next Topic:	Primary keys, sequenes and blocks

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 20:59:19 CST 2025