Steve
If you already have the CustNub2 and you only want to find out if the
unitlist is y, n or null then why not just do this.
SEL COUNT(*) INTO vrows INDIC iv1 FROM Specinstr WHERE Custnub2 =
.this_custnub2 AND UnitList = 'Y'
IF vrows > 0 THEN
SET VAR vcheck_list = ('Test1')
ELSE
SET VAR vcheck_list = ('Test2')
ENDIF
Buddy
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Steve
Breen
Sent: Sunday, November 09, 2008 8:05 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: I do not have it right yet, do I ?
Got it finally
SET VAR V1 INTEGER = NULL
SELECT CUSTNUB2 INTO V1 INDICATOR IV1 FROM SPECINSTR +
WHERE UNITLIST LIKE 'Y%' +
AND CUSTNUB2 = .THIS_CUSTNUB2
IF V1 = .THIS_CUSTNUB2 THEN
SET VAR VCHECK_LIST = 'TEST1'
ENDIF
SET VAR V2 INTEGER = NULL
SELECT CUSTNUB2 INTO V2 INDICATOR IV2 FROM SPECINSTR +
WHERE (UNITLIST LIKE 'N%' OR UNITLIST IS NULL)+
AND CUSTNUB2 = .THIS_CUSTNUB2
IF V2 = .THIS_CUSTNUB2 THEN
SET VAR VCHECK_LIST = 'TEST2'
ENDIF
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Walker,
Buddy
Sent: Sunday, November 09, 2008 7:10 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: I do not have it right yet, do I ?
Steve
It appears that you are selecting all Custnub2 where unitlist = Y or N.
If Custnub2 is unique in specinstr table then you must use the custnub2
in the where clause.
From the R:>
SELECT * CUSTNUB2 FROM SPECINSTR WHERE UNITLIST LIKE 'Y%'
You will notice that is gives you all CustNumb2 where unitlist like
'Y' that is where the "To many rows returned" occurs.
Buddy
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Steve
Breen
Sent: Sunday, November 09, 2008 6:15 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: I do not have it right yet, do I ?
Claudine,
This is my problem.
I get this result every time.
R>RUN A110808T
-ERROR- Too many rows returned (2441)
Switching input back to keyboard
The criteria the needs to be meant is the .vthis_custnub2 must =
custnub2 in specinstr and unitlist in specinstr must = 'Y' or 'N'
Can't get past this returning to may rows. Should return only one.
Custnub2 is unique in specinstr.
Thanks
Steve
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Claudine
Robbins
Sent: Sunday, November 09, 2008 12:41 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: I do not have it right yet, do I ?
Steve,
Try this:
SET VAR V1 INTEGER = NULL
SELECT CUSTNUB2 INTO V1 INDICATOR IV1 FROM SPECINSTR WHERE UNITLIST LIKE
'Y%'
IF V1 = .VTHIS_CUSTNUB2 THEN
SET VAR VCHECK_LIST = 'TEST1'
ENDIF
SET VAR V2 INTEGER = NULL
SELECT CUSTNUB2 INTO V2 INDICATOR IV2 FROM SPECINSTR WHERE UNITLIST LIKE
'N%'
IF V2 = .VTHIS_CUSTNUB2 THEN
SET VAR VCHECK_LIST = 'TEST2'
ENDIF
Claudine
________________________________________
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Steve
Breen
Sent: Saturday, November 08, 2008 10:05 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - I do not have it right yet, do I ?
-- test command A100808T
-- Set variable vCheck_List
-- Used to remind a user to Check A Spread Sheet for Customer Equipment
Verifcation
-- Major Assumption - var This_CustNub2 is set on form entry
-- This is being used as a entry - exit eep Clear var vCheck_List if
.vthis_custnub2 = custnub2 in specinstr and UnitList like 'Y' then set
var vCheck_List = 'test1'
if .vthis_custnub2 = custnub2 in specinstr and UnitList like 'N' then
set var vCheck_List = 'test2'
endif
