[kalkol]

i use vb6 and my sql give me error
can some one look at it and tell me what i am doing wrong?

mysql = ("select *  from test where id >=" & Text1.Text And products = " & Text3.Text & ") 

this code give me errore

mysql = "select *  from test where id >=" & Text1.Text And products = '" & Text3.Text & "'"

and try this but give me error too

mysql = "select *  from test where id >=" & Text1.Text And (products = '" & Text3.Text & "')"

and try this but give me error too

[maj3091]

perhaps if you told us what the error is, it would be easier to help you.

Looking at your code, check out where you have quotes, it appears you're missing some!

[andrewsw]

In each case you are missing a double-quote ".

Re-writing the expression several times though will not help you to fix it. Stick with one and get the quotes in the right place. If the expression itself is then found to be incorrect then you can work to find the correct expression.

[kalkol]

maj3091, on 13 March 2013 - 06:33 AM, said:

perhaps if you told us what the error is, it would be easier to help you.

Looking at your code, check out where you have quotes, it appears you're missing some!

Private Sub Form_Load()
Set mydatabase = OpenDatabase(App.Path + "\go1.mdb", False, False)

End Sub

Private Sub Command1_Click()
Dim mysql As String
Dim rs As Recordset
Dim x As Integer
x = 0


[color="#FFFF00"]  mysql = "select *  from test where id >=" & Text1.Text And products = '" & Text3.Text & "'"[/color]
    
       
   Set rs = mydatabase.OpenRecordset(mysql)
  
   Do While Not rs.EOF
   x = rs!qty + x
   Text2.Text = x
        rs.MoveNext
        Loop
        
        
End Sub

error Message is syntax error

[andrewsw]

Try this:

 mysql = "select *  from test where id >=" & Text1.Text & " And products = '" & Text3.Text & "'"

[BobRodes]

The " and products = '" is part of your SQL command, so it needs to be a literal string here. Andrew has given you the answer; I hope you will still go to the trouble of learning how to avoid making that sort of mistake in future.