Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to use this in select - SQL
Message
 
To
28/03/2006 06:35:24
Mk Sharma
Shrishti Solutions
Mumbai, India
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01108273
Message ID:
01108288
Views:
22
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform