Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Syntax of SQLEXEC
Message
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:
00960868
Views:
7
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
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform