Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Insert SQL
Message
From
13/12/1997 01:41:34
Anderson Girardi
Athenas Automação de Escritório
Porto Alegre, Brazil
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Insert SQL
Miscellaneous
Thread ID:
00065719
Message ID:
00065719
Views:
60
Hello All!!!

I did create a connection with Mysql, but i'm having any problems to insert data in the table i'm using the follow sintax:


CREATE CONNECTION tCONECTAR DATASOURCE MySQL USERID guest
STORE SQLCONNECT("MySQL", "guest") TO nCONECTAR
RESP=SQLEXEC(nCONECTAR,'INSERT INTO cartoes VALUES(0,0,'3', 'E', Another Room' )', 'MyCursor')
=SQLDISCONNECT(nCONECTAR)

But when i see in the table the data are'nt in the table

Anyone knows what i have to do?


Thanks
Next
Reply
Map
View

Click here to load this message in the networking platform