[Openroad-users] SetFieldValue fails in AppServer

[James Higson]

Thanks Bodo.
 
The missing quote was a typo in the email only.  I had the quote in the
code.
 
If it works in OR2006, that is good news. Perhaps we can try it there.

  _____  

From: openroad-users-bounces at peerlessit.com
[mailto:openroad-users-bounces at peerlessit.com] On Behalf Of Bodo Bergmann
Sent: Friday, 21 September 2007 17:19
To: James.Higson at gui-tek.com.au
Cc: International OpenROAD Users
Subject: Re: [Openroad-users] SetFieldValue fails in AppServer


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/20070923/05fd28f6/attachment.html