I Have a Database called Cars, with the next fields: Marca, Modelo, Color
My components are:
1 edit called txtmarca
1 Myquery
1 button
2 DBedit, to show modelo and color
My code in MyQuery is:
SELECT *FROM cars
WHERE marca=marca
My button:
MyQuery.close;
MyQuery.SQL.clear;
MyQuery.SQL.Text:='SELECT *FROM cars WHERE marca="'+txtmarca.text+'"';
MyQuery.Open;
I think that everything is ok, but I cant see the results in my DBedit.
Example:
When I write in marca='Ford'
I need to show Modelo=Lobo and color=Rojo
etc.......
P.S thanks