Hi


I have a problem with a Query , im usin free tables dbf

m_prec

The Structure is

NAME TYPE LEN DECIMALS

CONTRATO C 10 0
PRODUCTO CHARACTER 15 0
DESC1 CHARACTER 40 0
PRECIO NUMERIC 16 2

m_cont
m_prod

NAME TYPE LEN DECIMALS
PRODUCTO C 15 0
LINEA C 3 0
MARCA C 3 0
SUBLINEA C 3 0
UNIDAD C 10 0
IMPUESTO N 16 2


NAME TYPE LEN DECIMALS

CONTRATO C 10 0
CLIENTE C 6 0
ZUCURSAL C 6 0
VIGENCIA D 8

The Query is

Select prod.Producto, prod2.Desc1, prod.Precio, prod.Contrato, prod2.marca,
prod2.Linea, prod2.sublinea, prod2.UNIDAD, prod2.impuesto from m_prec prod,
m_prod prod2, m_cont cont where prod.producto=prod2.producto and
prod.contrato=cont.contrato and Vigencia>='17/09/2009' and
prod.Cliente='021085' and cont.Zucursal='000046'

The problem I have is when in the table m_prec the producto is VEDVDVD+R if
I quit de simbol "+" VEDVDVDR there is no problem.

With the simbole "+" the Query don´t respond

I appreciate if somebody help me

thanks

You might want to repost this with a little more
clarification ... it is not at all obvious what
VEDVDVD+R or VEDVDVD
represents.

If VEDVDVD+R is a column or variable name
then you'll need to quote that to show that is
is a single identifier and not some sort of
computation.

Try "VEDVDVD+R" instead.


"Roberto Negrete Cervantes" <rnegrete (AT) solretroactivas (DOT) com.mx> wrote in
message news:4ab2776e (AT) forums-1-dub (DOT) ..