Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sql with set dele off
Message
De
11/09/2006 05:06:11
 
 
À
11/09/2006 04:37:22
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 SP2
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01152709
Message ID:
01152714
Vues:
21
>should i use like :
>first i should create a tag like :
>
>
>sele 0
>use \\192.168.0.1\d\sales\inward1 excl
>sele inward1
>inde on deleted() tag delrec binary
>use
>
>
>should i use like below when i use sql :
>
>
>sele 0
>use \\192.168.0.1\d\sales\inward1
>sele inward1
>set order to delrec
>select * from inward1 into dbf xxcc
>
>
>warm regards,
>mk.
* sele 0 && not necessary
* use \\192.168.0.1\d\sales\inward1 && not necessary
* sele inward1 && not necessary
* set order to delrec && not necessary
* select * from inward1 into dbf xxcc && Change into
select * from \\192.168.0.1\d\sales\inward1 into table xxcc && But I suggest you add a "where" condition
select * from \\192.168.0.1\d\sales\inward1 into table xxcc where yourfield = yourvalue
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform