Posted: Mon Aug 20, 2007 11:41 am Post subject: مشكل در دستور update
سلام
من اين كد را براي دستور update مر بوط به پايگاه داده sql server در vb نوشتم ولي اين خطا را ميده
ممنون ميشم هر چه سريعنر راهنمايي كنيد
Incoorid syntax near “(“.
كد برنامه
Private Sub Command4_Click()
Dim cmd As New ADODB.Command
With cmd
.ActiveConnection = Adodc1.ConnectionString
.CommandType = adCmdText
.CommandText = " update tblstudent SET (ID_Number,name,family,age,madrak) =
( ,CStr(Val(Text1)), CStr(Text2), CStr(Text3),CStr(Text4), CStr(Text5))"
.Execute
Adodc1.Refresh
End With
End Sub
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum