>>Hi guys
>>
>>my maid a invoice application and I try to make a select of the last child invoice record. I use a transaction number to distinct wich record i already select like " no_trans >= transaction born 1 and no_trans < transaction born 2 "
>>
>>The problem is sometime it miss some child invoice record in the select
>>
>>i check if it was between my range of transaction and it was
>>i check if it was in table and it was but all field contain the caractere "
" like when we make a one to many relation but i dont have relation on the table
>>i check the buffering mode and the buffering is on "NO BUFFERING"
>>
>>what is very weard it if i maid the same select twice one right after the other the second always work fine
>>
>>Do you have an idee ?
>>All comments will apreciate
>>
>>Rocky Boy
>
>I'm not sure if it is what is happening becuase you didn't postyour SQL, but what it sounds like is that the first query is opening the table, and the second query uses the value in the field of the active record in the now open table for the JOIN or WHERE clause. If you open the specified table previously, then the first and second queries should return the same results. (Same as if you explicitly close the table after the first query)
>
>HTH

Thank's Erik
I will try that and give you some news