Conditional scan, using if - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Conditional scan, using if

Message

From

15/02/2014 05:20:25

Rick Hodgin
Alabama, United States

To

15/02/2014 04:15:47

Moises Pereira
Acrisoft
São Paulo, Brazil

General information

Forum:

Visual FoxPro

Category:

Coding, syntax & commands

Title:

Re: Conditional scan, using if

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:

01594378

Views:

100

This message has been marked as the solution to the initial question of the thread.

select mytable

scan for iif(empty(variable1), field2 = variable2, field1 = variable1)
    * Code here
endscan

Click here to load this message in the networking platform