Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dates on ODBC
Message
From
20/05/2003 08:19:35
Erick Miranda
Formata Data Business - Grupo Linx
Contagem, Brazil
 
 
To
20/05/2003 06:33:44
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Miscellaneous
Thread ID:
00790343
Message ID:
00790373
Views:
19
Hi José!

Try this:
 1 - Create the ODBC connection.
 2 - Use SqlConnect function to connect ODBC. Eg.: 
     lnCon = SqlConnect("TesteDBF", "", "").
 3 - Use SqlConnect function to Select, Insert, Delete data from table. Eg.:
     SqlExec(lnCon, "Select * From MyTable")
     SqlExec(lnCon, "Insert Into MyTable (Field1, Field2) Values (Val1, Val2)")
     SqlExec(lnCon, "Delete From MyTable Where Field1 = 1")
 4 - Use SqlDisConnect function to disconnect ODBC. Eg.:
     SqlDisconnect(lnCon)
I hope this help you!
Bye!
(Fuerza Siempre!)
Erick
Força Sempre!
Strength Always!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform