Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to optmize this SQL
Message
 
 
À
29/09/2007 04:22:54
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:
01257567
Message ID:
01257595
Vues:
12
You cannot. It's a price you pay for using WITH (BUFFERING = .T.) clause.

>i already have a TAG on DELETED() .
>
>
>SELECT qty,amt,plusminamt,Scheme,tdamt,cdamt,excise,taxamt,vatamt,octroi,freight,cnamt,Add,less,tbamt ;
>FROM inward1 WITH BUFFERING = .T. WHERE reco1=lxreco1 INTO CURSOR tempinward1
>
>
>above command giving error :
>
>command contains unrecognized phrase/keyword
>
>if i use like below this working perfect but Partial Optimized.
>
>
>SELECT qty,amt,plusminamt,Scheme,tdamt,cdamt,excise,taxamt,vatamt,octroi,freight,cnamt,Add,less,tbamt ;
>FROM inward1 WITH (BUFFERING = .T.) WHERE reco1=lxreco1 INTO CURSOR tempinward1
>
>
>
>
>SELECT qty,amt,plusminamt,Scheme,tdamt,cdamt,excise,taxamt,vatamt,octroi,freight,cnamt,Add,less,tbamt ;
>FROM inward1 WHERE reco1=lxreco1 INTO CURSOR tempinward1
>
>
>above Select Sql is Full Optmized.
>
>
>SELECT qty,amt,plusminamt,Scheme,tdamt,cdamt,excise,taxamt,vatamt,octroi,freight,cnamt,Add,less,tbamt ;
>FROM inward1 WITH (BUFFERING = .T.) WHERE reco1=lxreco1 INTO CURSOR tempinward1
>
>
>above Select Sql is Partial Optmized.
>
>Difference is Only :
>
>WITH (BUFFERING = .T.)
>
>
>
>warm regards,
>mk.
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform