Re: SQL*Forms 3.0 / MasterBlock & Join Clause

From: Gv Fragante <fragante_at_unixg.ubc.ca>
Date: Thu, 2 Apr 1992 18:11:29 GMT
Message-ID: <fragante.702238289@chilko.ucs.ubc.ca>

In <1992Apr1.205713.3152_at_deepthought.uucp> deepthought!neil_at_ms.uky.edu (Neil Greene) writes:

>> deepthought/neil% cat MS.err
>> PL/SQL error 49 at line 3, column 27:
>> bad bind variable 'LICENSEE.LICENSEEID'
>> FRM-30137: Compile Error on procedure CLEAR_LICENSEE_DETAILS.
>> PL/SQL error 49 at line 3, column 7:
>> bad bind variable 'LICENSEE.LICENSEEID'
>> FRM-30137: Compile Error on procedure QUERY_LICENSEE_DETAILS.
>> PL/SQL error 49 at line 3, column 20:
>> bad bind variable 'LICENSEE.LICENSEEID'
>> FRM-30133: Compile Error on trigger KEY-DELREC.
>--

Try putting a colon (:) before the variables listed above., The general format for reference these kind of variables (form fields) is:

:<block>.<fieldname>

Hope this helps. Received on Thu Apr 02 1992 - 12:11:29 CST