Home » Developer & Programmer » Forms » HOW TO OPEN
HOW TO OPEN [message #233586] Thu, 26 April 2007 13:44 Go to next message
Messages: 141
Registered: November 2006
Location: india
Senior Member

hi everyone,
i created a module(database block "yes") in forms and
after entering some data ,there is a button to open other form ,when i open it and when i insert something in recently opened form i tried to save it but it gives an error(i.e. ORACLE error unable to insert),i think in my case it counts first block also at the time of saving.
even at the time of opening the other form (shared library is off,sessions are different too).
i want to ask that
Is it been possible to open a form in different window but this it save the data perfectly.......

hope ur reply soon......
Re: HOW TO OPEN [message #233589 is a reply to message #233586] Thu, 26 April 2007 14:19 Go to previous message
Messages: 20847
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'd say that you should first detect the error, then think of something else. In other words, find out what causes UNABLE TO INSERT RECORD. While in form, click Help - Show Error (or Display Error or something like this). It will describe what went wrong (for example, "you can not insert NULL into a NOT NULL column" or "insufficient privileges" or "table or view does not exist" or ...). Now you should be able to fix the error and move on.
Previous Topic: comparision query
Next Topic: ActiveX
Goto Forum:

Current Time: Tue Oct 25 18:02:10 CDT 2016

Total time taken to generate the page: 0.11551 seconds