Unix Technical Forum

Informix 4GL and dates

This is a discussion on Informix 4GL and dates within the Informix forums, part of the Database Server Software category; --> I'm trying to test a bug report for Aubit4GL - can someone with Informix 4GL try this code : ...


Go Back   Unix Technical Forum > Database Server Software > Informix

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-19-2008, 07:38 PM
Mike Aubury
 
Posts: n/a
Default Informix 4GL and dates

I'm trying to test a bug report for Aubit4GL - can someone with Informix 4GL
try this code :


main
define xdate date
let xdate="31/31/31"
display xdate
end main


Does it error out - or just display xdate as being null (ie blank) and not
say anything?


Aubit currently errors out :

Err:Program stopped at 't1.4gl', line number 4.
Error status number -30087.
Error in conversion.

4gl function call stack :
MAIN

(Although you could obviously "whenever error continue" over it)

Which is what I thought Informix 4GL would do....

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-19-2008, 07:38 PM
John Carlson
 
Posts: n/a
Default Re: Informix 4GL and dates

On Mon, 08 Sep 2003 16:36:49 +0100, Mike Aubury <mike@aubit.com>
wrote:

>I'm trying to test a bug report for Aubit4GL - can someone with Informix 4GL
>try this code :
>
>
>main
>define xdate date
>let xdate="31/31/31"
>display xdate
>end main
>
>
>Does it error out - or just display xdate as being null (ie blank) and not
>say anything?
>
>
>Aubit currently errors out :
>
>Err:Program stopped at 't1.4gl', line number 4.
>Error status number -30087.
>Error in conversion.
>
>4gl function call stack :
> MAIN
>
>(Although you could obviously "whenever error continue" over it)
>
>Which is what I thought Informix 4GL would do....


It's null -- 4gl version is 7.30.hc7

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-19-2008, 07:38 PM
Jonathan Leffler
 
Posts: n/a
Default Re: Informix 4GL and dates

Mike Aubury wrote:

> I'm trying to test a bug report for Aubit4GL - can someone with Informix 4GL
> try this code :
>
>
> main
> define xdate date
> let xdate="31/31/31"
> display xdate
> end main
>
>
> Does it error out - or just display xdate as being null (ie blank) and not
> say anything?
>
>
> Aubit currently errors out :
>
> Err:Program stopped at 't1.4gl', line number 4.
> Error status number -30087.
> Error in conversion.
>
> 4gl function call stack :
> MAIN
>
> (Although you could obviously "whenever error continue" over it)
>
> Which is what I thought Informix 4GL would do....
>


It depends on whether you have WHENEVER ANY ERROR handling set. By
default, as others confirmed, it will continue. You can make it stop
by saying "WHENEVER ANY ERROR STOP". OTOH, that is a hack, pure and
complex (anything but simple), because of changes made
semi-consciously in I4GL 4.10 and progressively fixed in later
versions. (The first release I was directly involved in was 4.12;
part of the progressive fixing phase.)

--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 09:40 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com