Hi, I`m trying to open an MSHFlexGrid showing only the rows in an Adodc that I want it to. The code I`m using:
Adodc1.RecordSource = "SELECT * FROM Estudiantes WHERE Profesor LIKE '%" & Str(numero) & "'%;"
Adodc1.Refresh
flexdata.Refresh
It keeps telling me that there´s an error with the SELECT...FROM line and then of course another ont with the Adodc line.
Could you help?:confused