Submit My Question - Recent Questions - Recent Answer
Msdn China Tech >> PowerBuilder >> 基础类

SQL问题

我想在sqlserver两个数据库中用insert into ...select ...from ...
方式把数据导过来请问在pb中怎样写，涉及到两个事务对象
[86 byte] By [newyoungman-newyoungman] at [2007-12-12]
«« help:关于CListCtrl控件（急!）
»» 我有一个picturebox,怎样做commondialog中选一个图片后,picturebox就刷新?
# 1
太easy
多定义一个事物对象
1）在全局定义变量里定义transaction b_sqlca

2）和sqlca那个一样，定义第二个
b_SQLCA=create transaction
b_SQLCA.DBMS = "ODBC"
b_SQLCA.AutoCommit = false
b_SQLCA.DBParm = "Connectstring='DSN=bdzd;UID=dba;PWD=sql'"
connect using zdb_sqlca;

3）写sql语句时，在最后加上using b_sqlca;
如果不加,他会取默认的sqlca.
千万搞清使用哪个哦。
jiazhij-雨中漫步 at 2007-10-24 > top of Msdn China Tech,PowerBuilder,基础类...
PowerBuilder
基础类

PowerBuilder Hot Topic

PowerBuilder New Topic

PowerBuilder

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified