I have this SQL query
If (ocon.ConnectTo("AS400DB2", "", "")) Then
Set oqry.Connection = ocon
SQLStringVar = "select docsrc,payee,dtetrn from D100.APPAY where payee=1061"
oqry.SQL = SQLStringVar
when I use a where clause I get no data BUT if I remove the where clause its okey. What's going on?