This sql query can be short

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

This sql query can be short

Message

21/07/2010 18:48:51

Naomi Nosonovsky
Wisconsin, États-Unis

21/07/2010 18:36:50

Khubaib Khalid
Kps
Haroonabad, Pakistan

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

Re: This sql query can be short

Versions des environnements

Visual FoxPro:

VFP 9 SP2

OS:

Windows 7

Network:

Windows XP

Database:

Visual FoxPro

Divers

Thread ID:

01473412

Message ID:

01473414

Vues:

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

>i want to this sql query short and speedy for update records.
>

>UPDATE res SET p01="Fail"  WHERE p01<m01 
>UPDATE res SET p01="Pass" WHERE p01>m01 
>
>UPDATE res SET p02="Fail" WHERE p02<m02 
>UPDATE res SET p02="Pass" WHERE p02>m02  
>UPDATE res SET p03="Fail" WHERE p03<m03 
>UPDATE res SET p03="Pass" WHERE p03>m
>......up to  30
>

Update res 
SET po1 = IIF(po1<mo1, "Fail","Pass"), po2 = IIF(po2<mo2, "Fail", "Pass"), etc.

If it's not broken, fix it until it is.

My Blog

Répondre

Fil

Voir

Click here to load this message in the networking platform