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/
<!--
#ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean, sans-serif;}
#ygrp-mlmsg table {font-size:inherit;font:100%;}
#ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean,
sans-serif;}
#ygrp-mlmsg pre, code {font:115% monospace;}
#ygrp-mlmsg * {line-height:1.22em;}
#ygrp-text{
font-family:Georgia;
}
#ygrp-text p{
margin:0 0 1em 0;}
#ygrp-tpmsgs{
font-family:Arial;
clear:both;}
#ygrp-vitnav{
padding-top:10px;font-family:Verdana;font-size:77%;margin:0;}
#ygrp-vitnav a{
padding:0 1px;}
#ygrp-actbar{
clear:both;margin:25px 0;white-space:nowrap;color:#666;text-align:right;}
#ygrp-actbar .left{
float:left;white-space:nowrap;}
.bld{font-weight:bold;}
#ygrp-grft{
font-family:Verdana;font-size:77%;padding:15px 0;}
#ygrp-ft{
font-family:verdana;font-size:77%;border-top:1px solid #666;
padding:5px 0;
}
#ygrp-mlmsg #logo{
padding-bottom:10px;}
#ygrp-vital{
background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;}
#ygrp-vital #vithd{
font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-transform:uppercase;}
#ygrp-vital ul{
padding:0;margin:2px 0;}
#ygrp-vital ul li{
list-style-type:none;clear:both;border:1px solid #e0ecee;
}
#ygrp-vital ul li .ct{
font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;padding-right:.5em;}
#ygrp-vital ul li .cat{
font-weight:bold;}
#ygrp-vital a {
text-decoration:none;}
#ygrp-vital a:hover{
text-decoration:underline;}
#ygrp-sponsor #hd{
color:#999;font-size:77%;}
#ygrp-sponsor #ov{
padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;}
#ygrp-sponsor #ov ul{
padding:0 0 0 8px;margin:0;}
#ygrp-sponsor #ov li{
list-style-type:square;padding:6px 0;font-size:77%;}
#ygrp-sponsor #ov li a{
text-decoration:none;font-size:130%;}
#ygrp-sponsor #nc {
background-color:#eee;margin-bottom:20px;padding:0 8px;}
#ygrp-sponsor .ad{
padding:8px 0;}
#ygrp-sponsor .ad #hd1{
font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-height:122%;}
#ygrp-sponsor .ad a{
text-decoration:none;}
#ygrp-sponsor .ad a:hover{
text-decoration:underline;}
#ygrp-sponsor .ad p{
margin:0;}
o {font-size:0;}
.MsoNormal {
margin:0 0 0 0;}
#ygrp-text tt{
font-size:120%;}
blockquote{margin:0 0 0 4px;}
.replbq {margin:4;}
-->
Don't be flakey. Get Yahoo! Mail for Mobile and always stay connected to
friends. http://mobile.yahoo.com/mail
