[Openroad-users] SetFieldValue fails in AppServer

[James Higson]

Since this is AppServer, I don't have a form to attach it to.  I have tried
dozens of weird-n-wonderful things to try and fool OpenROAD into being
friendly, but to no avail.

  _____  

From: openroad-users-bounces at peerlessit.com
[mailto:openroad-users-bounces at peerlessit.com] On Behalf Of Sean Thrower
Sent: Sunday, 23 September 2007 23:13
To: James.Higson at gui-tek.com.au; International OpenROAD Users
Subject: Re: [Openroad-users] SetFieldValue fails in AppServer



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