>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

---

Joao,
Hard to follow :) Probably it's "Order by". Temporarily remove order by part and check if you get it. If You don't, instead of fieldnames use coolumnorder in order by clause (ie: select myF1, myF2, myF3 from .... order by 2,3,1).
Cetin