You are right Mike. The Stored Procedure that follows get var pon text as
input and check for the existence of special chars except greek, english,
numeric and '-' chars. If there is, it appears the position and the
character with a message. If not it returns null.
What appears as 'greek' to you, are greek chars. Thanks.
*(ElOn.STP: Stored Procedure AeYa?io IiiiUoui aea aeaeeiyo ?anaeo?nao)
--pon: c ?anUiaonio oio iiuiaoio iY?ne 30, aea a?ui,iiii,?aon
--stp: oi ea?iaii oio eUeioo
--A?eonY?iioae ie 0-9,A-Z,A-U,'-'
CLEAR VAR stp_return
SET V stp TEXT,plen INTE,p1t TEXT,pi INTE
--an?eeYo oeiYo
SET V stp = NULL,pi = 0
SET V plen = (SLEN(pon))
IF plen = 0 THEN ; GOTO LOUT ; ENDIF
WHILE pi < .plen THEN
SET V pi = (.pi + 1)
SET V p1t = (SGET(.pon,1,.pi))
IF p1t BETW 'A' AND 'U' OR p1t BETW 'A' AND 'Z' OR p1t BETW '0' AND '9'
THEN
CONTI
ENDIF
IF p1t = '-' THEN
CONTI
ENDIF
IF p1t = ' ' THEN ; SET V p1t = '[eaiu]' ; ENDIF
SET V stp = ('EYoc:' + (CTXT(.pi)) + ', I? a?eona?ouo ?anaeo?nao:' + .p1t)
BREAK
ENDW
LABEL LOUT
CLEA VAR p%
RETURN .stp
>
> We need to see the contents of your Stored Procedure....
>
> ----- Original Message -----
> From: "ELOEN" <[EMAIL PROTECTED]>
> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]>
> Sent: Friday, January 03, 2003 1:41 AM
> Subject: [RBASE-L] - Stored Procedure in Where Clause
>
>
> > Hello brotherhood of R!
> >
> > could someone confirm this?
> >
> > If I use a stored procedure in a WHERE clause, it returns all
> the rows in
> > the table.
> > For example:
> >
> > SELE ... WHERE (CALL stp_name(stp_prmtrs)) IS NOT NULL
> >
> > returns all the rows, where as
> >
> > SELE (CALL stp_name(stp_prmtrs)) FROM ...
> >
> > returns null and not null values.
> >
> > OS: win2k
> > Rbase Vers:1.862 x RT03 Win
> >
> > TIA
> > Polychronis T. Kontos
> > Athens, Greece
> >
> >
>
