Re: Disturbing Asset Discovery

Terri,

This is a problem that I have encountered too.  If your SQL statement is
within a condition, the compile will fail as the END statement never gets
into the source (compile error 5177).  Otherwise, it is down to thorough
testing of the program to ensure it does what it is meant to!

Not very helpful - but there's ASSET for you!

Regards,

Sally

-------------------------------------
Sally Bosman
Director - Small Blue Ltd
Tel:   +44 1737 824246
Fax:  +44 1737 824247
Mob: +44 7767 447107
www.smallblue.co.uk


----- Original Message -----
From: <THarteau@xxxxxxxxxxxxxxxxxx>
To: <bpcs-l@xxxxxxxxxxxx>
Sent: Tuesday, March 18, 2003 7:19 PM
Subject: Disturbing Asset Discovery


> Hi,
>       We are on BPCS V6.04 with that same version of Asset. I made a copy
> of an existing Asset program that has many SQL commands in it. I changed
my
> primary file to another one.  It compiled fine and ran with no halts. As I
> was looking at the data, I found some items that did not update correctly.
> I traced it back to a subroutine with an SQL declare followed by the open,
> fetch and a bunch of other calculations. When I looked at the asset
source,
> everything was fine.  When I put it in debug, I entered the SR, but there
> was nothing there.
>       What had happened was that in the where portion of the declare, I
had
> a field that was no longer defined.  The only RPG code generated for the
> subroutine was BEGSR & ENDSR. No compile error, no run error, no code.
The
> scary part is this SR only affected about 1/4 of the items. I could have
> very easily looked at some items and thought everything was OK, and put it
> into production. Luckily, I'm kind of anal sometimes :)
>       Is it normal that SQL statements are not checked for validity? When
I
> fixed the field name, everything was OK.
>
> <===================================================>
>
> Terri Harteau
> ****************
> "There's no point in being grown up if you can't be childish sometimes."
> - Dr. Who
> ****************
>
>
>
>
>
>
> _______________________________________________
> This is the SSA's BPCS ERP System (BPCS-L) mailing list
> To post a message email: BPCS-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
> or email: BPCS-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/bpcs-l.
>
>