WOLFRAM

Wolfram 语言与系统参考资料中心

SQLResultSetCurrent[rs]

reads the current row from a result set.

更多信息和选项
Details and Options Details and Options
范例  
基本范例  
Options  
"GetAsStrings"  
Possible Issues  
参见
技术笔记
相关指南
DatabaseLink`
DatabaseLink`

SQLResultSetCurrent

SQLResultSetCurrent[rs]

reads the current row from a result set.

更多信息和选项

范例

打开所有单元 关闭所有单元

基本范例  (1)

Wolfram Language code: Needs["DatabaseLink`"]

If you find that the examples in this section do not work as shown, you may need to install or restore the example database with the DatabaseLink`DatabaseExamples` package, as described in Using the Example Databases.

Open a connection:

Wolfram Language code: conn = OpenSQLConnection["publisher"];

Open a result set:

Wolfram Language code: rs = SQLResultSetOpen[SQLSelect[conn, "roysched"]]

Shift the current position to the first row:

Wolfram Language code: SQLResultSetShift[rs, 1];
Wolfram Language code: SQLResultSetPosition[rs]

Get the current row:

Wolfram Language code: SQLResultSetCurrent[rs]

Close the result set:

Wolfram Language code: SQLResultSetClose[rs]
Wolfram Language code: CloseSQLConnection[conn];

Options  (1)

"GetAsStrings"  (1)

Wolfram Language code: Needs["DatabaseLink`"]
Wolfram Language code: conn = OpenSQLConnection["publisher"];
Wolfram Language code: rs = SQLResultSetOpen[SQLSelect[conn, "roysched"]];
Wolfram Language code: SQLResultSetShift[rs, 1];
Wolfram Language code: SQLResultSetCurrent[rs, "GetAsStrings" -> True]//InputForm
Wolfram Language code: SQLResultSetClose[rs]
Wolfram Language code: CloseSQLConnection[conn];

Possible Issues  (1)

Wolfram Language code: Needs["DatabaseLink`"]
Wolfram Language code: conn = OpenSQLConnection["publisher"];
Wolfram Language code: rs = SQLResultSetOpen[SQLSelect[conn, "roysched"]];

There is nothing to read before the first row:

Wolfram Language code: SQLResultSetPosition[rs]
Wolfram Language code: SQLResultSetCurrent[rs]

There is nothing to read after the last row:

Wolfram Language code: SQLResultSetGoto[rs, Infinity];
Wolfram Language code: SQLResultSetPosition[rs]
Wolfram Language code: SQLResultSetCurrent[rs]
Wolfram Language code: SQLResultSetClose[rs]
Wolfram Language code: CloseSQLConnection[conn];