Re: Form Builder PL/SQL editor error messages

[Quoted] Peter, the Colan (:) is required to reference a form object. This is the cause of at least one of the errors. Additionally, "TYPE" is an Oracle reserved word. You can use reserved words as table/column names, but it is not recommended.

Anyway, to fix the error, use the following: :Rental.Rego_No and :Vehicle.Vehicle_Type.

Hope this helps.

Craig....

In article <8grlv6$v20$1_at_nnrp1.deja.com>, sanrenkur_at_my-deja.com wrote:
>In article <39306f1a$0$2626_at_news01.syd.optusnet.com.au>,
> "Peter Mount" <pmount_at_optusnet.com.au> wrote:
>> Hello
>>
>> I'm following an example (a procedure under the Program Units
 node)
 straight
>> from a text book. When I first typed it in, word for word
 (except
 for when
>> it said to my own name in), it had a lot more error
 messages. I get
 the
>> feeling the text book I'm using is wrong on this example.
 Everybody
 else is
>> having trouble with it and I only just today managed to
 reduce the
 number of
>> error messages.
>
>
>Hi
>I think you need to have a colon(:) in front of your Forms
 items.
>Hth
>Sanrenkur
>
>>
>> When I'm in the PL/SQL editor trying to add data into extra
 text
 items on a
>> tabbed form canvas (from the Type and Vehicle tables) I get
 the
 following
>> errors:
>>
>> "Error 201 at line 14, column 10
>> Identifier 'type' must be declared
>>
>> Error 0 at line 11, column 4
>> SQL statement ignored"
>>
>> The code is:
>>
>> /* Procedure Name: Get_Vehicle_Details
>> Author: Peter Mount
>> Date: 26/5/2000
>> Purpose: Retrieve the Vehicle details into the
>> Vehicle_Rental Form
>> */
>>
>> PROCEDURE Get_Vehicle_Details IS
>> BEGIN
>>
>> SELECT Make,Model, Color, Transmission, Location
>> INTO Rental.Make, Rental.Model, Rental.Color,
>> Rental.Transmission, Rental.Location
>> FROM Type, Vehicle
>> WHERE Rental.Rego_No = Vehicle.Rego_No
>> AND Vehicle.Vehicle_Type = Type.Vehicle_Type;
>>
>> EXCEPTION
>> /* If an invalid Rego No is entered and
>> the vehicle details are not found give the user
>> a message and reset the form */
>>
>> WHEN
>> NO_DATA_FOUND
>> THEN
>> MESSAGE ('No Vehicle Details Found');
>> RAISE FORM_TRIGGER_FAILURE;
>> END;
>>
>> Thanks in advance for your help
>>
>> Peter Mount
>> pmount_at_optusnet.com.au
>>
>>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
>
>

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!