Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Where is the WHERE clause in the code you showed (I don't see one)?
>>I'm just reading you rthread and I have two suggestions to test.
>>
>>1) If you do the select Other without the "go top" does it work?
>>2) Replace the "Select Other and go top statement" with a wait windows with a little comment. If it works, it might be a speed related issue.
>>
>>As I said these are just ideas I had and it might not lead you anywhere.
>
>Well, after more research, I found that the mistake was of course in the code. :)
>
>Unpredictable results will occur if you insert a WHERE clause having an alias which is not used in the SQL. As soon as I discovered it and replaced it with the proper alias, all started to work as expected.
Précédent
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