如下片断:
TransAction myodbc
myodbc = create transaction
myodbc.dbms = 'odbc '
myodbc.autocommit = false
myodbc.dbparm = "connectstring= 'dsn=et-log;uid=;pwd=; ' "
connect using myodbc;
dw_1.settransobject(MYODBC)
dw_1.retrieve()
ids_et = create datastore
ids_et.settransobject(myodbc)
ids_et.dataobject = 'dwo_et_log '
ids_et.retrieve()
//messagebox( 'COUNT FOR IDS_ET ',ids_et.rowcount())
DISCONNECT USING MYODBC;
DESTROY MYODBC
destroy ids_et
dw_1里面的数据窗口对象就是dwo_et_log,运行后,DW_1里面有上千条数据,但是ids_et 一直是零记录,怎么回事????
请赐教!!!!!!
------解决方案--------------------
ids_et = create datastore
ids_et.settransobject(myodbc)
ids_et.dataobject = 'dwo_et_log '
ids_et.retrieve()
---------------------------------------------
改为下面试试:
ids_et = create datastore
ids_et.dataobject = 'dwo_et_log '
ids_et.settransobject(myodbc)
ids_et.retrieve()
------解决方案--------------------
先
ids_et.dataobject = 'dwo_et_log '
再
ids_et.settransobject(myodbc)