Very basic SQL clause will not return a value either in vb or SQL even though the table definately has the data included. Machine is selected in a combobox and the selectedindexchange event is used.
I can run it without the where clause and it works fine and I10 is definately a machine listed. Machine is a varchar(15), don't know if that should make any difference in the statement.
SELECT OEE As OEE, Hour As Hour FROM qry_OEE_Hourly_Machine WHERE Machine ='I10'
SQL.RunQuery("SELECT OEE As OEE, Hour As Hour FROM qry_OEE_Hourly_Machine WHERE Machine ='" & cboMachine.Text & "' ")