Dear,
// New Transaction Create
sqlcb = CREATE transaction
// Profile sqlcb
sqlcb.DBMS = "ODBC"
sqlcb.AutoCommit = False
sqlcb.DBParm = "ConnectString='DSN=attndb',CommitOnDisconnect='No'"
Connect Using sqlcb;
Dw_1.settransobject( sqlcb )
Dw_1.retrieve()
Moga bisa membantu
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of
tukang ketik
Sent: Monday, February 04, 2008 10:31 AM
To: [email protected]
Subject: Re: [indopb] buka .dbf dan .mdb ?
Thanks, disimpan sudah gak error lagi, tapi waktu running ada error :
Application terminated.
Error: Null object reference at line 22 in open event of object w_main_dbase
source code seperti ini...
// Profile dBase
SQLCA.DBMS = "ODBC"
SQLCA.AutoCommit = False
SQLCA.DBParm = "ConnectString='DSN=dBASE
Files;UID=;PWD=;defaultdir=f:\test\;dbname=lottest.dbf',CommitOnDisconnect='
No'"
connect;
dw_1.setTransObject( sqlca)
dw_1.retrieve()
// Profile MDB Access
Transaction SQLCB // <--- aku tambahin disini Transaction SQLCB nya
SQLCB.DBMS = "ODBC" // <----- di script ini line 22
SQLCB.AutoCommit = False
SQLCB.DBParm =
"ConnectString='DSN=Timbangan;UID=;PWD=',CommitOnDisconnect='No'"
connect;
dw_2.settransobject( sqlcb)
dw_2.retrieve( )
Thanks
On 2/4/08, Rio Albert <[EMAIL PROTECTED]> wrote:
Di deklarasiin dulu mas SQLCB nya
Transaction SQLCB
_____
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of
tukang ketik
Sent: Monday, February 04, 2008 9:33 AM
To: [email protected]
Subject: Re: [indopb] buka .dbf dan .mdb ?
Udah saya coba, tapi waktu disimpan muncul error...
---------- Compiler: Errors
coba-coba.pbl(w_main_dbase).w_main_dbase.open.18: Error C0015:
Undefined variable: sqlcb
coba-coba.pbl(w_main_dbase).w_main_dbase.open.19: Error C0015:
Undefined variable: sqlcb
coba-coba.pbl(w_main_dbase).w_main_dbase.open.20: Error C0015:
Undefined variable: sqlcb
coba-coba.pbl(w_main_dbase).w_main_dbase.open.23: Error C0015:
Undefined variable: sqlcb
---------- Finished Errors
<<image001.jpg>>
<<image002.jpg>>
