atau bisa juga pake aja messagebox SQLCA.SQLERRTEXT ketika mau action ke DB...
Gudlak..
-rio-
----- Original Message -----
From: Firman Setiawan
To: [EMAIL PROTECTED]
Sent: Wednesday, April 11, 2007 10:59 PM
Subject: Re: [indopb] gimana menangkap error
saya bukan pakar tp saya coba kasih masukan mungkin berguna
simpan dalam datawindow di event dberror
String ls_msg
CHOOSE CASE sqldbcode
CASE -1
ls_msg = "Can't connect to the database " + &
"~r~nbecause of missing values in the transaction
object·"
CASE -2
ls_msg = "Can't connect to the database"
CASE -3
ls_msg = "The key specified in an Update or Retrieve no longer
matches an existing row." + &
"~r~nThis can happen when another user has changed the
row after you retrieved it·"
CASE -4
ls_msg = "Writing a blob to the database failed"
CASE 2627
ls_msg = "Duplicate code, please enter another code"
CASE 515
ls_msg = 'Data doesnt complete'
CASE 547
ls_msg = 'Data conflict, there`s an invalid entry'
CASE 8115
ls_msg = 'Data overflow numeric conversion'
CASE ELSE
ls_msg = sqlerrtext
END CHOOSE
MessageBox('DB Error SIT:' + String(sqldbcode), ls_msg)
RETURN 1
Selamat mencoba
----- Original Message ----
From: Rudi Hartono <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Sent: Thursday, April 12, 2007 12:49:17 PM
Subject: [indopb] gimana menangkap error
dear pber's
saya mau tanya nih,
kalo mau nangkap adanya error gimana?
apakah sintaknya dg try catch finally atau dg yg lain
karena sy agak bingung dimana sy harus letakkan
kodenya
tolong kasih script sederhanya, misal waktu menyimpan
ternyata data ga bisa tersimpan krn alasan tertentu
nah gmn kita mengetahui nomer errornya dan description
errornya melalui messagebox.
sbg perbandingan : kalo di vb sy meletakan object
error spt ini :
on error goto adaError
....
kode-kode yg diperiksa errornya
adaError:
...
kode yg menampilkan kenapa ada error
trimakasih.
note : sy benar2 hrs mulai dari bawah nih utk belajar
powerbuilder (capeee deh hehehhe)
salam
rudi
____________ _________ _________ _________ _________ _________ _
Looking for earth-friendly autos?
Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center.
http://autos. yahoo.com/ green_center/
------------------------------------------------------------------------------
Need Mail bonding?
Go to the Yahoo! Mail Q&A for great tips from Yahoo! Answers users.
Disclaimer: Although this message has been checked for all known viruses
using Trend Micro InterScan Messaging Security Suite, Bukopin
accept no liability for any loss or damage arising
from the use of this E-Mail or attachments.
Disclaimer: Although this message has been checked for all known viruses
using Trend Micro InterScan Messaging Security Suite, Bukopin
accept no liability for any loss or damage arising
from the use of this E-Mail or attachments.
