I have a problem in VB trying to use select statements with MySQL. My problem does not occur only with the example below but with ANY select statement I try to make against my MySQL database. Much thanks in advance to anyone that can help me out with this :)
This is my code: Private Sub optNoTech_Click() Adodc1.RecordSource = "Select * from usermanager where techstatus = 'U'" Adodc1.Refresh DataGrid1.Refresh End Sub I keep getting this error: [MySQL][ODBC 3.51 Driver][mysqld-3.23.49.nt]You have an error in your SQL syntax near "Select * from usermanager where techstatus = 'U'" at line 1. Thanks :) -Trevor --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php