Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Conditional scan, using if
Message
From
15/02/2014 05:09:33
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01594372
Message ID:
01594376
Views:
44
Try This.
select mytable
if empty (variable1)
scan for field2 = variable2
Endscan
Else
scan for field1 = variable1
Endscan
Endif
>HI
>
>I am not succeeding by using the structure below:
>Looks like case or if does not match with scan.
>
>==========================================================
>select mytable
>
> if empty (variable1)
>
> scan for field2 = variable2
>
> else
>
> scan for field1 = variable1
>
> endif
>
>
> endscan
>===========================================================
Harsh
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform