Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to use this in select - SQL
Message
 
À
28/03/2006 06:35:24
Mk Sharma
Shrishti Solutions
Mumbai, Inde
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01108273
Message ID:
01108288
Vues:
20
Did you try my first post?

>mydate=ctod("01/01/2006")
>mydate1=ctod("28/02/2006")
>sele a
>use igroup
>inde on igroup for selg='Y' to selig
>
>sele b
>use pcode1
>set rela to igroup into igroup addi
>inde on pcode for found("igroup") to selpc
>
>sele c
>use selsal
>inde on billno for sels='Y' to selbill
>
>use sales1
>set order to billdate
>set rela to billno into selsal addi
>set rela to pcode into pcode1 addi
>
>seek mydate
>copy to tsales1 for found("selsal") and found("pcode1") WHILE BILLDATE<=MYDATE1
>SELE F
>USE TSALES1
>
>please help me.
>
>WARM REGARDS,
>MK.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform