Sorry still not working.
Error message "Column ? not found" where ? is the name from the edit box.
I think I have to declare the param and send a value to it so that it can be integrated into the sql statement.
Tried this but still no luck
query1.param[0].asstring:=edit1.text;
and this...
Sorry tried the new code still the same error.
Think problem has to do with setting parameters for the text thats in the edit box, I think.
Thanks for that
New user to SQLQuery
I have a problem, here is a simplified code on a buttons on-click event
query1.Close;
query1.SQL.Clear;
query1.SQL.Add('SELECT EMP_NO, FIRST_NAME, FULL_NAME, LAST_NAME, SALARY' );
query1.SQL.Add('FROM EMPLOYEE');
query1.sql.Add('WHERE FIRST_NAME='+edit1.Text)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.