Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Determining if record found in scan
Message
From
26/03/2003 17:41:37
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00770498
Message ID:
00770507
Views:
12
if you don't want to use the seek command try this:
>
>SELECT lv_x_emp_itc
>SCAN
>	DO CASE
>	
>		CASE lv_x_emp_itc.upd_status == 'A' 	&& add
>		
>		
>		CASE lv_x_emp_itc.upd_status == 'C'		&& change
>			SELECT rv_udfield
			FoundIt = .f.
                                SCAN FOR rv_udfield.ssno == lv_x_emp_itc.ssno
>			
>			--------->>>>??? how do I know if my find was successful
                                   FoundIt = .t.
                                   exit
>       
>			ENDSCAN
                                if FoundIt = .t.
                                   * *** alright - we got the first match
                                endif
>				
>		CASE lv_x_emp_itc.upd_status == 'D' 	&& delete			
>			SELECT rv_udfield
			FoundIt = .f.
>			SCAN FOR rv_udfield.ssno == lv_x_emp_itc.ssno
>			
>				--------->>>> ??? how do I know if my find was successful
                                   FoundIt = .t.
                                   exit
>			
>			ENDSCAN
                                if FoundIt = .t.
                                   * *** alright - we got the first match
                                endif
>	ENDCASE
>ENDSCAN
>ENDWITH
>
>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform