sepertinya errornya di syntax query untuk update date
coba jalani syntax querynya di sql analyzer
coba untuk mengupdate field satu persatu
selamat coding
--- SrIe RaTrIaNI <[EMAIL PROTECTED]> wrote:
>
> Dear all
>
> kenapa muncul err message "Line 4: Incorrect syntax
> near ',' "
> mohon koreksi vb-ers untuk pot program saya ini:
> FYI : Con adalah connection database
>
> Private Sub cmdupdate_click()
>
> Dim qry As String
>
> If MsgBox("anda ingin mengupdate data ini ?",
> vbYesNo, "UpDate Message") = vbNo Then
> Unload Me
> Else
> qry = "Begin transaction" & Chr(10)
> qry = qry + ("update x_apisp set narration = '" &
> DataGrid1.Columns(1) & "' , amount=" &
> dataGrid1.Columns(2) & " WHERE DOC_NO = '" & DoC &
> "' AND SEQUENCE = " & DataGrid1.Columns(0) & "") &
> Chr(10)
> qry = qry + ("update apisp set doc_No = '" & DoC
> & "', doc_date = '" & Date & "', reference_no = '" &
> reff & "', AUTHORIZER_1 = '" & CmbAuth1 & "',
> AUTHORIZER_2 = '" & CmbAuth2 & "',AUTHORIZER_3 = '"
> & CmbAuth3 & "',project = '" & Prj &
> "',AUTH1_DESC='" & auth1 & "',AUTH2_DESC='" & auth2
> & "' WHERE DOC_NO = '" & DoC & "'") & Chr(10)
> qry = qry + "Commit transaction, con,1,3"
>
> Con.Execute qry
>
> CmdLihat.SetFocus
> End If
> CmdUpdate.Enabled = False
>
> End Sub
>
> atau hasil dari immediate windowsnya seperti ini :
>
>
> Begin transaction
> update x_apisp set narration = 'Beli' ,
> amount=1000.00 WHERE DOC_NO = '005/RBA/TEST' AND
> SEQUENCE = 1
> update apisp set doc_No = '005/RBA/TEST', doc_date =
> '06-May-07', reference_no = '', AUTHORIZER_1 =
> 'Suprianto', AUTHORIZER_2 = 'Andre ',AUTHORIZER_3 =
> 'Lenih',project = '',AUTH1_DESC='',AUTH2_DESC=''
> WHERE DOC_NO = '005/RBA/TEST'
> Commit transaction,con,1,3
>
> Mohon Pencerahannya,
> rgds
> ian
>
> [Non-text portions of this message have been
> removed]
>
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Untuk berhenti berlangganan kirim email kosong ke : [EMAIL PROTECTED]
Forum ini berkembang dengan pesat, jika anda memiliki
dedikasi dan waktu, silahkan mengaplikasikan diri
menjadi moderator.
SPONSORED LINKS
| Computer internet security | Computer internet business | Computer internet access |
| Computer internet privacy securities | Computer internet help | Computer internet connection |
YAHOO! GROUPS LINKS
- Visit your group "indoprog-vb" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
