>Does anybody has knowledge about problems with joining tables with records that were deleted and after recalled in VFP 6.0 SP3
>
>The follwing select
>
>SELECT lojista.*, fatura.*, municip.nmmunicip, ;
> produto.nmproduto, itemfat.qtproduto ;
> FROM lojista, fatura, municip, itemfat, produto ;
> WHERE fatura.nrfatura = itemfat.nrfatura AND ;
> itemfat.nrproduto = produto.nrproduto AND ;
> fatura.nrlojista = lojista.nrlojista AND ;
> fatura.nrfatura >= thisform.txtnrfaturainicial.value AND ;
> fatura.nrfatura <= thisform.txtnrfaturafinal.value AND ;
> lojista.nrmunicipio = municip.nrmunicip ;
> INTO CURSOR impfatura ;
> ORDER BY fatura.nrfatura, produto.nmproduto
>
>works fine for some records but not for others.
>
>If I run the same command in VFP 5.0 it works ok, always.
>
>Is is VFP 6.0 bug?
Sorry, but I think my problem is related with collating sequence, because I have changed the collate sequence to GENERAL. There are some bugs in MS knowledge base related with this.
However, the weird is that all the fields used to make the comparison are numeric fields. How collate sequence can modify the results for SQL statments when the join condition uses just numeric fields?
Antonio Carlos Kleinübing
Systems Analyst