Btw who ever ask this question, "mas tukang ketik" lah atau mas "duniamaya"
lah atau mungkin mba.

Untuk koneksi ke database selain SQLCA(karma SQLCA merupakan default untuk
konektifitas pada PB)  harus disertakan nama transactionnya begitu di
connect in.

Jadi use this one sentence :

 

Connect suing SQLCB ;

 

Mudah2 an membantu

-rio-

 

  _____  

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 <it_ahsupport@
<mailto:[EMAIL PROTECTED]> abdainsurance.co.id> wrote: 

Di deklarasiin dulu mas SQLCB nya 

 

Transaction SQLCB

 

  _____  

From: [EMAIL PROTECTED] <mailto:[email protected]> com
[mailto:[EMAIL PROTECTED] <mailto:[email protected]> com] On Behalf
Of tukang ketik
Sent: Monday, February 04, 2008 9:33 AM
To: [EMAIL PROTECTED] <mailto:[email protected]> com
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


 

 

 

Kirim email ke