[Openroad-users] SetFieldValue fails in AppServer

[Bodo Bergmann]

After replacing
    entryfld.DataType = F8 NOT NULL';
    (which would lead to a compile error due to a missing quote
character)
with either
    entryfld.DataType = 'F8 NOT NULL';
or
    entryfld.DataType = 'FLOAT(8) NOT NULL';

it works fine for me (in an OR2006 Server).
 
So, it could be either a bug in OR4.1SP3 or
you have some different environment settings (e.g. II_DECIMAL,
II_4GL_DECIMAL) when running in AppServer.
 
Bodo.
 
Bodo Bergmann
Senior Software Engineer
OpenROAD Worldwide Development
Ingres Corp.
 

________________________________

From: openroad-users-bounces at peerlessit.com
[mailto:openroad-users-bounces at peerlessit.com] On Behalf Of James Higson
Sent: Friday, September 21, 2007 1:01 AM
To: 'International OpenROAD Users'
Subject: [Openroad-users] SetFieldValue fails in AppServer


Hi all,
 
We are running OR SP3.
 
The following procedure runs fine in ClientServer mode, but causes
AppServer to return the exception "Ingres or 4GL runtime error. Please
check the w4gl.log file for details".  I have narrowed it down to the
command SetFieldValue.  If I comment out that line, it works fine.
 
I assume this is a bug in AppServer.  Before I waste Ingres' time by
reporting it, can anyone see a problem.
 
PROCEDURE report_4gl () =
DECLARE
    scratch     = StringObject;
    entryfld    = EntryField DEFAULT NULL;
ENDDECLARE
{
    scratch.Value = '';
    entryfld = EntryField.Create();
    entryfld.DataType = F8 NOT NULL';
    entryfld.FormatString = '"$,$$$,$$$,$$n.nn"';
    entryfld.SetFieldValue(Value = 123.45);
    scratch.ConcatVarchar(Text=entryfld.TextValue);
    RETURN ER_OK;
}
 
Thanks,
James
Melbourne, Australia
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.peerlessit.com/pipermail/openroad-users/attachments/20070921/76941e29/attachment.html