Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Determining if record found in scan
Message
From
26/03/2003 19:33:21
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00770498
Message ID:
00770558
Views:
8
>I have the following code that has nested scans:
>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
>			SCAN FOR rv_udfield.ssno == lv_x_emp_itc.ssno
>			
>			--------->>>>??? how do I know if my find was successful
				If !EOF('lv_x_emp_itc')
				   * do whatever
				endif

>			ENDSCAN
>				
>		CASE lv_x_emp_itc.upd_status == 'D' 	&& delete			
>			SELECT rv_udfield
>			SCAN FOR rv_udfield.ssno == lv_x_emp_itc.ssno
>			
>				--------->>>> ??? how do I know if my find was successful
				If !EOF('lv_x_emp_itc')
				   * do whatever
				endif

>			ENDSCAN
>	ENDCASE
>ENDSCAN
>ENDWITH
>
>
>
>How can I determine if my second scan has found the record sucessfully. I can't use found() function so what do I use or look for.
>
>Thanks
>Nick Patel
Previous
Reply
Map
View

Click here to load this message in the networking platform