sqlconnectstring='DRIVER=SQLServer;SERVER=yourservername;UID=run;PWD=111111;DATABASE=test;Network=DBMSSOCN'
nhdl=sqlconnect(sqlconnectstring)
sqlexec(nhdl,"select * from weituo","a_cursor")
if there are more than one results returned,their names should be a_cursor,a_cursor1,a_cursor2,...
you can browse them as :
select a_cursor
brow
select a_cursor1
brow
... ...
谢谢,但能否再请教一个问题,为什么在foxpro中可以不用sql server or sybase中自带的sybfront.h/syberror.h文件,而在vc中要#include "sybfront.h",还有在foxpro中执行查询dbtest库中的order表,在.prg中这样写为什么返回不了值?
sqlconnect('test','run','111111') //库为 test.user=run,pass=111111
sqlexec("select * from weituo")
如果是指定的服务器呢?比如不是本机,是远程的服务器,那怎么指定?谢谢了。