Home » Developer & Programmer » Forms » forms6i insert problem
forms6i insert problem [message #82369] Thu, 22 May 2003 03:40 Go to next message
jels
Messages: 29
Registered: April 2003
Junior Member
i created an application in forms6i.i able to scroll next,pre,etc using code.When i am trying to insert data and try to save the record i am getting this error
frm -40508 unable to insert record.
i created two blocks one for pushbuttons and one for basetable connection
i code i wrote is also correct
it was next_block
create_record;
when i am trying from menu that is predefined it also giving same errors.the user have the privileges pls hlp
bye
jels
Re: forms6i insert problem [message #82370 is a reply to message #82369] Thu, 22 May 2003 04:36 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Try Shift+F1 when you get the FRM-40508. Normally, this will display the Oracle (server) message. Find it, and post it if it doesn't help you out. The error occurs at server side, not client side, so most probably your code in forms *IS* correct (at least for the insert part).

MHE
Re: forms6i insert problem/thank u [message #82375 is a reply to message #82370] Thu, 22 May 2003 13:09 Go to previous message
jels
Messages: 29
Registered: April 2003
Junior Member
its worked the error was a presicion point in datatype.REaly really thank u for the tip
when i am trying to implement a search function i am getting this error.I think the code is
not correct.I don'nt have much exp in application development in forms.i have exp in vb and
i am oracle certified (ocp 9i).would u hlp me to provide some guideline by clearing the doughts can u give ur mailid
FRM-40505 ORACLE error unable to perform query

go_block('product_master');
go_item('product_no');
select product_no into :product_master.product_no from product_master
where product_no = :product_master.product_no;
enter_query;
Previous Topic: automatic display of LOV
Next Topic: How to repeat a query
Goto Forum:
  


Current Time: Tue Jul 02 05:22:13 CDT 2024