Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Updating a field without going through each record
Message
 
À
28/01/2003 06:53:48
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00746132
Message ID:
00746145
Vues:
19
Create updateable view of Table A innerjoining with Table B then replace the resultset with .T.

>hello!
>
>i use this command to update a logical field in table A which exists in table B.
>
>SELE 1
>USE a
>GO TOP
>SELE 2
>USE b
>GO TOP
>
>SELE 1
>DO WHILE .NOT. EOF()
> SCATTER MEMVAR
> SELE 2
> GO TOP
> LOCATE FOR m.checkno=checkno AND agycode=agycode
> IF FOUND()
> SELE 1
> REPLACE ttype WITH .T.
> ENDIF
> SELE 1
> SKIP
>ENDDO
>
>
>any better way than this?
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net

CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform