|
-
Oct 18th, 2007, 02:40 AM
#1
Thread Starter
Fanatic Member
Need help missing Operators...
why there is missing operator error in this codes "SELECT * RSOQuerryFinal where RsoNo='" & UsePrinRSONO & "'"
by the way this from excel and the like the two sheet in the access then those two sheet Put it in the Query and that querry in where in use here... called" RSOQuerryFinal "
then, here is my codes
why there is missing operator as i said above?
Private Sub GetRecords(ByVal UsePrinRSONO As String)
Try
ds = New DataSet
Dim cmd As New OleDbCommand
cmd.Connection = cn
cmd.CommandType = CommandType.Text
cmd.CommandText = "SELECT * RSOQuerryFinal where RsoNo='" & UsePrinRSONO & "'"
da = New OleDbDataAdapter
da.SelectCommand = cmd
da.Fill(ds, "RSOQuerryFinal")
Catch ex As Exception
MsgBox(ex.ToString)
MsgBox(ex.Message)
End Try
End Sub
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|