error sql query in vb6

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • masoen
    New Member
    • May 2010
    • 1

    error sql query in vb6

    Code:
    Private Sub lskk_Click()
    Dim stsql As String
    stsql = " SELECT romaji,hiragana,btkkamus, vp1.hslperub as hp1, vp2.hslperub as hp2,vp3.hslperub as hp3,vp4.hslperub as hp4"
    stsql = stsql & " FROM jepang inner join mengalami vp1 on jepang.idjp=vp1.idjp inner join mengalami vp2 on jepang.idjp=vp2.idjp"
    stsql = stsql & " inner join mengalami vp3 on jepang.idjp=vp3.idjp inner join mengalami vp4 on jepang.idjp=vp4.idjp"
    stsql = stsql & " where vp1.idperub = 'p1' and vp2.idperub ='p2' and vp3.idperub ='p3' and vp4.idperub ='p4' and romaji like '" & lskk & "'"
    Debug.Print stsql
    Set rskata = konek.Execute(stsql)
    Set DGkk.DataSource = rskata.DataSource
    
    End Sub
    when i clicked the lskk it should display the result in DGkk, but error occure say missing operator in query expression ... please help me..
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    What is iskk and dgkk ?

    copy the sql from debug window and check the syntax if it is proper .

    Comment

    Working...