problema con where

[[maeyanes]]

Prueba con esto:

Código SQL [-]
SELECT (producto) as art, (codigo) as C, (grupo) as g art FROM artic WHERE art = 'correa'

Esto en Delphi sería:

Código Delphi [-]
ADOQuery1.SQL.Add('SELECT (producto) as art, (codigo) as C, (grupo) as g art FROM artic WHERE art = ''correa''');

Saludos...