Home » Developer & Programmer » Forms » Forms Builder PL/SQL (ORACLE FORMS BUILDER for ORA10G)
Forms Builder PL/SQL [message #355457] Fri, 24 October 2008 03:10 Go to next message
Alcatros
Messages: 2
Registered: October 2008
Location: Australia
Junior Member
Hi guys,

I'am having a problem.

I got a Layout and i have a button which is supposed to create a "fresh page" where i can insert new values



Select cust_seq.nextval from dual;

It says after it needs a into statement... so i thought yea that makes sense ...

Select cust_seq.nextval into customer_form_field from dual;

My layout has 4 Fields where i can input data, 2 buttons one is supposed to create a new entry and the other should save the inputted data.

after that it doesn't work either.. and i have no idea why?
Can somebody give me some help?

Thanks very much!

Oliver

[Updated on: Fri, 24 October 2008 03:12]

Report message to a moderator

Re: Forms Builder PL/SQL [message #355460 is a reply to message #355457] Fri, 24 October 2008 03:24 Go to previous message
Alcatros
Messages: 2
Registered: October 2008
Location: Australia
Junior Member
Ok sorry for the stupid question, found out after posting and 4 hours of searching does it is

answer:

SELECT sequence.NEXTVAL
Into :dbtable.row_val
FROM dual;
Previous Topic: Migration 6i -> 10g, menu not showing
Next Topic: How to Get MAC Address within Forms
Goto Forum:
  


Current Time: Mon Nov 11 02:23:39 CST 2024