[Openroad-users] SetFieldValue fails in AppServer

[Sean Thrower]

James,

Try parenting the entryfield before the setfieldvalue - that may make
the difference.

Regards,

Sean.

 

________________________________

From: openroad-users-bounces at peerlessit.com
[mailto:openroad-users-bounces at peerlessit.com] On Behalf Of James Higson
Sent: 23 September 2007 13:58
To: 'International OpenROAD Users'
Subject: Re: [Openroad-users] SetFieldValue fails in AppServer

 

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/0779dd9d/attachment.html