Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Syntax of SQLEXEC
Message
From
12/11/2004 11:26:33
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00960758
Message ID:
00960878
Views:
8
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform