1,108
社区成员
发帖
与我相关
我的任务
分享关于sqlca
谁有关于sqlca的详细资料？我想知道的是相关sqlcode等属性具体的值表示什么意思，麻烦大家了！
在网上找了半天，发现没有详细的资料，之前查到一个相关问题，看了看答案还是没有找到满意的，由于机器里没装数据库，所以没办法查help，希望可以在这里得到高手们的帮助，谢谢！
在网上找了半天，发现没有详细的资料，之前查到一个相关问题，看了看答案还是没有找到满意的，由于机器里没装数据库，所以没办法查help，希望可以在这里得到高手们的帮助，谢谢！
...全文
请发表友善的回复…
发表回复
青葱岁月不可追 2008-04-07
- 打赏
- 举报
谢谢大家！
lllyyymmm 2008-04-07
- 打赏
- 举报
0 Success
100 Fetched row not found
-1 Error; the statement failed. Use SQLErrText or SQLDBCode to obtain the detail.
100 Fetched row not found
-1 Error; the statement failed. Use SQLErrText or SQLDBCode to obtain the detail.
青葱岁月不可追 2008-04-07
- 打赏
- 举报
如果是infomax数据库的话，这三个值表示什么意思啊？
机器内存太小，什么数据库也没装，只是通过远程登录到infomax数据库。
机器内存太小，什么数据库也没装，只是通过远程登录到infomax数据库。
leio 2008-04-07
- 打赏
- 举报
联机帮助里就有
sqlcode就三个值0,100,-1
dw的dberror事件有个参数sqldbcode，这个值的具体含义不同的数据库是不同的，需要查相关数据库的手册。
sqlcode就三个值0,100,-1
dw的dberror事件有个参数sqldbcode，这个值的具体含义不同的数据库是不同的，需要查相关数据库的手册。
青葱岁月不可追 2008-04-07
- 打赏
- 举报
不好意思，我没装数据库，没法搜索，所以才上来向大家求助。
青锋-SS 2008-04-07
- 打赏
- 举报
晕死了,以Transaction object为关键字搜索一下PB的帮助即可.
青锋-SS 2008-04-07
- 打赏
- 举报
[code=HTML]Transaction property Data type Description
AutoCommit Boolean The automatic commit indicator (SQL Server only). Values are:?True ?Commit automatically after every database activity?False ?Do not commit automatically after every database activity
ClassDefinition PowerObject An object of type PowerObject containing information about the class definition of the object or control.
Database String The name of the database with which you are connecting.
DBMS String PowerBuilder vendor identifier.
DBParm String DBMS-specific parameters.
DBPass String The password that will be used to connect to the database.
Lock String The isolation level.
LogID String The name or ID of the user who will log on to the server.
LogPass String The password that will be used to log on to the server.
ServerName String The name of the server on which the database resides.
SQLCode Long The success or failure code of the most recent operation.Return codes:?0 ?Success?100 ?Not found?-1 ?Error (use SQLDBCode or SQLErrText to obtain the details)
SQLDBCode Long The database vendor's error code.
SQLErrText String The database vendor's error message.
SQLNRows Long The number of rows affected (the database vendor supplies this number, so the meaning may not be the same in every DBMS).
SQLReturnData String DBMS-specific information.
UserID String The name or ID of the user who will connect to the database.[/HTML]
AutoCommit Boolean The automatic commit indicator (SQL Server only). Values are:?True ?Commit automatically after every database activity?False ?Do not commit automatically after every database activity
ClassDefinition PowerObject An object of type PowerObject containing information about the class definition of the object or control.
Database String The name of the database with which you are connecting.
DBMS String PowerBuilder vendor identifier.
DBParm String DBMS-specific parameters.
DBPass String The password that will be used to connect to the database.
Lock String The isolation level.
LogID String The name or ID of the user who will log on to the server.
LogPass String The password that will be used to log on to the server.
ServerName String The name of the server on which the database resides.
SQLCode Long The success or failure code of the most recent operation.Return codes:?0 ?Success?100 ?Not found?-1 ?Error (use SQLDBCode or SQLErrText to obtain the details)
SQLDBCode Long The database vendor's error code.
SQLErrText String The database vendor's error message.
SQLNRows Long The number of rows affected (the database vendor supplies this number, so the meaning may not be the same in every DBMS).
SQLReturnData String DBMS-specific information.
UserID String The name or ID of the user who will connect to the database.[/HTML]
