deklarasi SQLDBnya taruh diglobal variabel biar di tiap event si SQLDB itu dikenal.
//global variable transaction gt_sqldb //biasakan menggunakan standar penamaan PFC gt_ (global transaction) instansiasikan SQLDB dan lakukan koneksi (biasanya di event opennya aplikasi) //application open() event gt_sqldb = create transaction // Profile MDB Access GT_SQLDB.DBMS = "ODBC" // <----- di script ini line 22 GT_SQLDB.AutoCommit = False GT_SQLDB.DBParm = "ConnectString='DSN=Timbangan;UID=;PWD=',CommitOnDisconnect='No'" connect USING GT_SQLDB; // <----- defaultnya ke SQLCA, pastikan dengan syntax USING dw_2.settransobject( GT_SQLDB) dw_2.retrieve( ) Jangan lupa untuk men-destroy si SQLDB sewaktu aplikasi terminated if isvalid( GT_SQLDB ) then destroy( GT_SQLDB ) end if > > 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 > > > > ----------------------------------------------- IndoPB - Indonesia PB User Group An Indonesian PowerBuilder User Group's Event 2nd PowerBuilder Update Rumah Sakit Jantung Harapan Kita 26/27 August 2006 To Register : http://groups.yahoo.com/group/indopb/database?method=addRecord&tbl=4 Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indopb/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indopb/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
