游标变量不能用作远程过程调用的参数。
A cursor variable cannot be used as a parameter to a remote procedure call.
在局部变量、游标和临时表的声明方面,两种平台没什么差别,但在这两种平台上,声明的顺序却很重要。
There are no differences in the declarations of local variables, cursors, temporary tables, but on both platforms the order of declaration is important.
最后一个游标的SQLERROR被返回,而最后一个失败的sql语句的错误字符串将被存储到变量SQLERRSTR中。
SQLERROR of the last cursor is returned, and the error string of the latest failed SQL statement is stored into variable SQLERRSTR.
除了从游标获得数据之外,可以使用三种不同的技术将来自单行查询的值装载进变量中。
In addition to fetching data out of cursors, you can load values from a single row query into variables using three different techniques.
变量 $this 表示XML游标的当前位置。
The variable $this denotes the current position of the XML cursor.
下一步检查游标是否包含记录,如果包含记录,侧记录ID字段的值存储在ID变量中。
Next check if the cursor contains records and if so loop through them. The record ID field is stored in the id variable. This will be used as a where parameter later.
下一步检查游标是否包含记录,如果包含记录,侧记录ID字段的值存储在ID变量中。
Next check if the cursor contains records and if so loop through them. The record ID field is stored in the id variable. This will be used as a where parameter later.
应用推荐