主题:ODBC 问题! 有趣
我用的是VB+SQL server,执行语句成功.代码如下:
DB_Connect
SqlStmt = "SELECT Pwd FROM Users WHERE UserName='" _
+ Trim(TmpUser) + "'"
OdbcExt (SqlStmt)
If SQLFetch(Hstmt) <> SQL_NO_DATA_FOUND Then
ColVal = String(40, 0)
Rc = SQLGetData(Hstmt, 1, 1, ColVal, Len(ColVal), pcblen)
GetId = Val(ColVal)
End If
Rc = SQLFreeStmt(Hstmt, SQL_DROP)
DB_Disconnect
我要取Pwd字段的信息,怎么做?????????????
谢谢各位大虾指点[em15]
DB_Connect
SqlStmt = "SELECT Pwd FROM Users WHERE UserName='" _
+ Trim(TmpUser) + "'"
OdbcExt (SqlStmt)
If SQLFetch(Hstmt) <> SQL_NO_DATA_FOUND Then
ColVal = String(40, 0)
Rc = SQLGetData(Hstmt, 1, 1, ColVal, Len(ColVal), pcblen)
GetId = Val(ColVal)
End If
Rc = SQLFreeStmt(Hstmt, SQL_DROP)
DB_Disconnect
我要取Pwd字段的信息,怎么做?????????????
谢谢各位大虾指点[em15]