Home » Developer & Programmer » Forms » semicolon " : " in oracle forms (oracle all version)
semicolon " : " in oracle forms [message #676179] Sun, 19 May 2019 08:43 Go to next message
spirit3d
Messages: 4
Registered: May 2019
Junior Member
Dear all,

I am new to oracle and would be grateful if you could advice me.

As far as i know
If i have a form with block name "swimming_block" and field name like "swim_id", "swim_name" etc ...

In Order to insert data into database from this form, i should say

INSERT INTO SWIMMING
VALUES (:SWIMING_BLOCK.SWIM_ID, :SWIMMING_BLOCK.SWIM_NAME)

I would like to know:
(1) where do we need to use semicolon " : " in oracle forms (Pl/SQl editor)
(2) where not to use it

Many thanks

Tairon

Re: semicolon " : " in oracle forms [message #676180 is a reply to message #676179] Sun, 19 May 2019 16:04 Go to previous messageGo to next message
Littlefoot
Messages: 21482
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
First, terminology.
- ":" is "colon"
- ";" is "semi-colon"

INSERT you wrote is correct. Though, I'd suggest you to name all columns you're inserting into, e.g.
insert into swimming (swim_id, swim_name)
  values (:swimming_block.swim_id, :swimming_block.swim_name);

Use a colon when referencing form items. Don't use it in built-ins, such as
set_item_property('swimming_block.swim_name', enabled, property_false);

Furthermore, a colon is used when referencing system variables, such as
:system.message_level := 5;
as well as global variables
:global.form_name := 'my_form';
or parameters
:parameter.trg_rec := :system.trigger_record;

There are probably some more examples I didn't mention. If in doubt, open Forms Online Help system, search for term you're interested in and see what it says. If you can't make it work, come here & ask a question; someone will assist.
Re: semicolon " : " in oracle forms [message #676185 is a reply to message #676180] Mon, 20 May 2019 03:05 Go to previous messageGo to next message
cookiemonster
Messages: 13630
Registered: September 2008
Location: Rainy Manchester
Senior Member
I think you've covered everything there.

The form builder help is pretty exhaustive with examples for everything. Those examples should make clear if a colon is needed or not.
Re: semicolon " : " in oracle forms [message #676203 is a reply to message #676180] Mon, 20 May 2019 17:10 Go to previous message
spirit3d
Messages: 4
Registered: May 2019
Junior Member
Thanks to you all

Previous Topic: Copy file using oracle forms 6i
Next Topic: MULTIPLE PROGRESS BAR FOR STORED PROCEDURE
Goto Forum:
  


Current Time: Mon Jun 24 03:53:44 CDT 2019