To search

VFP与sql server用作网络版程序

用sql (或Access数据库)
spt的连接,删除,更新,插入, 断开语句          
连接语句:cnn=sqlstringconnect("driver=sqlserver;server=SQL服务器IP;database=要连接的SQL数据库名;uid=SQL用户名;pwd=SQL口令;")
删除语句: sqlexec(cnn,"delete from table2 where c3=2")
更新语句: sqlexec(cnn,"update table2 set c1=5")
插入语句: sqlexec(cnn,"insert into table2 (c1) values ('ch')")
SQLDISCONNECT(0)  断开全部连接

看懂这几句,就基本上会了

They posted on the same topic

Trackback URL : http://www.92os.com/trackback/40

This post's comments feed

Page top