Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Syntax of SQLEXEC
Message
De
12/11/2004 11:26:33
 
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 8 SP1
Database:
Visual FoxPro
Divers
Thread ID:
00960758
Message ID:
00960878
Vues:
9
This message has been marked as a message which has helped to the initial question of the thread.
>I just hope that code will work, but :o(((
>So Your exit of this situation is what Martin said but You must incude it with cikle:
>
>
>
>SELECT BobClient
>SCAN
>   csql = "INSERT INTO IFCOMPAN ( CID, CNAME1, CNAME2, CADDRESS1, CZIPCODE, CLOCALITY, CVATCAT, "+;
>          " CCUSTYPE, CSUPTYPE, CCUSCAT, CCUSPAYDELAY ) VALUES ("+;
>          " ?BobClient.code, ?BobClient.nomteleph , ?BobClient.nom2 , ?BobClient.rue,"+;
>          " ?BobClient.cpays + ?BobClient.ccp , ?BobClient.localite , 'N' ,   'C' , 'U' ,"+;
>          " ?BobClient.codePersonnel , 30)"
>
>   nresult = SQLEXEC( lnAccess ,   csql)
>   IF nresult < 0
>      **** Error hapened
>   ENDIF
>ENDSCAN
>
>
Borislav, pardon me if I allow myself:
SELECT BobClient
csql = [INSERT INTO IFCOMPAN ( CID, CNAME1, CNAME2, CADDRESS1, CZIPCODE, CLOCALITY, CVATCAT,;
CCUSTYPE, CSUPTYPE, CCUSCAT, CCUSPAYDELAY ) VALUES (;
?code, ?nomteleph , ?nom2 , ?rue,?(cpays+ccp) , ?localite , 'N' , 'C' , 'U' ,;
?codePersonnel , 30)]
_TALLY=0
IF SQLPREPARE(m.lnAccess,m.csql)>0
  COUNT NOOPTIMIZE FOR SQLEXEC(m.mlnAccess)>0
  * with buffering
  *COUNT NOOPTIMIZE FOR SQLEXEC(m.mlnAccess)>0 AND TABLEUPDATE()
ENDIF
IF _TALLY<m.BobClientCount
	WAIT WINDOWS 'ERRORS'
ENDIF
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform