Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sql with set dele off
Message
From
11/09/2006 05:06:11
 
 
To
11/09/2006 04:37:22
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 SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01152709
Message ID:
01152714
Views:
19
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform