General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL - Litle problem...
Hi all,
I got an error only when i run this code for the first time only
lcP="010101000001"
lcU="010101000005"
SELECT * ;
FROM jbfic!documentoscabcli INNER JOIN jbfic!documentoslincli ;
on Documentoscabcli.c_tipodoc = documentoslincli.c_tipodoc;
AND Documentoscabcli.c_armazem = documentoslincli.c_armazem;
AND Documentoscabcli.c_cod_ser = documentoslincli.c_cod_ser;
AND Documentoscabcli.c_numdoc = documentoslincli.c_numdoc;
AND BETWEEN(Documentoscabcli.C_TIPODOC+Documentoscabcli.C_ARMAZEM+Documentoscabcli.C_COD_SER+Documentoscabcli.C_NUMDOC, lcP, lcU) ;
LEFT OUTER JOIN jbfic!documentos ;
LEFT OUTER JOIN jbfic!clientes ;
ON Documentoscabcli.c_tipodoc = Documentos.c_codigo ;
ON Documentoscabcli.c_codcli = clientes.c_codigo ;
ORDER BY Documentoscabcli.c_tipodoc, Documentoscabcli.c_armazem,;
Documentoscabcli.c_cod_ser, Documentoscabcli.c_numdoc;
into cursor fact
Error: SQL: Column 'c_tipodoc' is not found, Why?
Thank's in advance,
João Batista
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only