Information générale
Titre:
Weard sql select help
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement