From: jay vajramani <jvajrama@ford.com>
Subject: MAx length and query length in Forms 6.0
Date: 2000/06/06
Message-ID: <393D2062.50D7BD18@ford.com>#1/1
Content-Transfer-Encoding: 7bit
X-Accept-Language: en, en-GB, de, fr, ja, ko, zh
Content-Type: text/plain; charset=us-ascii
Organization: Ford Motor Company
Mime-Version: 1.0
Reply-To: fhasan@ford.com
Newsgroups: comp.databases.oracle.tools


Hi, I am converting forms from 4.5 to 6.0
One problem I am encountering is that:
I have a base table block and a field in it ( say partbase ) had Maximum Length
property set to 8 and Query length is set to 56.
In enter-query mode - pre-query- trigger - I am populating this field to
:block1.partbase := '#LIKE || ''''|| '3600'||'''' ;
It gives me a numeric or value error in this trigger.
But the same thing works perfectly in forms 4.5
THis looks like a bug in FOrms 6.0.
One workaround is increasing the Maximum Length of the field.
Any other smart soultion to this without changing the properties?
Let me know.
Thanks
Jay