>Hello comunity
>
>I need help about using na IF condition with LIKE
>
>for exemple on my code i have:
>IF LIKE('0.600/*',bi.ref)
> replace qtt with 1
>ELSE
>return
>ENDIF
>
>Note the field bi.ref = '0.600/1182'
>the problem is my IF with LIKE never work and i don´t know how to solve this problem.
>
>Many thanks,
>Luis Santos
Whats wrong with it?
CLEAR
CREATE CURSOR bi (ref c(10))
INSERT INTO bi VALUES ('A')
INSERT INTO bi VALUES ('0.600/1182')
INSERT INTO bi VALUES ('0.600/')
INSERT INTO bi VALUES ('0.600')
SCAN
IF LIKE('0.600/*',bi.ref) THEN
?bi.ref
ENDIF
ENDSCAN
runs prettty fine.
@Craig
Function LIKE() is part of VFP.
(VFP)SQL has its own (for example, with other quantifiers). You can use function LIKE(), but with problems on rushmore, for what I remember.
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]