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