Jump to content


Gregg Barr

Member Since 16 Nov 2001
Offline Last Active Feb 27 2006 02:55 PM
-----

Posts I've Made

In Topic: Superlayer

16 October 2003 - 09:06 PM

Obsolete?!? Don't tell Glovia (or their customers!)

In Topic: Making a field always mandatory.

10 December 2002 - 01:07 PM

I use Superlayer so don't know if this will help or not but I put an enable(&#@SUPP-EXIT) in the logic before of first screen field and a disable(&#@SUPP-EXIT) in the logic after of the last mandatory screen field. That appeared to fix the problem for me.

In Topic: Oracle Stored Procedures

11 November 2002 - 01:16 PM

Chuck,

PLSQLIN() clears some return variable.

003 @MSG = 0
004 @MSGTEXT = ''
005 @MSGARGS = ''
006 @SYSERR = ''
007 @SYSERRTEXT = ''

PLSQLOUT() does the following.

003 IF @SYSERRTEXT # '' THEN
004 MSG(99)
005 @LFUNCT = @RFUNCT
006 #STAT = ROLLBACK()
007 FNEXIT
008 ENDIF

In Topic: Oracle Stored Procedures

07 November 2002 - 08:12 PM

I use SL so I am not sure if this will help but here is an example from a Glovia SL function:

1 PLSQLIN()
2 $EFFDATE = CDATE(@DATE,'MMDDYYYY')
3 #QTY = 1
4 $ASSEM_QTY = CONV(#QTY)
5 SQL
6 BEGIN
7 U_MLBOM.MAIN(:$PROCESS_ID,:CCN,:ITEM,:REVISION,
8 'CUR', ' ',:#QTY,' ','Y',
9 TO_DATE(:$EFFDATE,'MMDDYYYY'),' ','S');
10 END;
11 ENDSQL
12 PLSQLOUT()

In oracle the package is defined like this:
CREATE OR REPLACE PACKAGE BODY 'GLOVIA_PROD'.'U_MLBOM' AS

S_CURRENT NUMBER;
S_TAIL NUMBER;
S_NEXT_LEVEL NUMBER;
**** More defs ****
.
.
.


PROCEDURE MAIN(P_PROCESS_ID S_MLBOM.PROCESS_ID%TYPE,
P_CCN CCN.CCN%TYPE,
P_ITEM BOM.ITEM%TYPE,
P_REVISION BOM.REVISION%TYPE,
P_BCR_TYPE BOM.BCR_TYPE%TYPE,
P_BCR_ALT BOM.BCR_ALT%TYPE,
P_ASSEM_QTY VARCHAR2,
P_INCL_COST VARCHAR2,
P_INCL_ALT VARCHAR2,
P_EFFDATE DATE,
P_SUMMARY VARCHAR2,
P_SORT VARCHAR2) IS

**** CODE GOES HERE ****
.
.
.


END MAIN;

END U_MLBOM;

Hope this helps.

In Topic: What OS do you use?

08 July 2002 - 11:18 AM

We are using Windows NT for our users.