>I don't see anything obvious. If it works and the performance is acceptable, go with it.
Actually I just found that performance is lower than what I have with VB and I don't understand why!
Performance was acceptable in my tests because I was always querying for the same table (@NomTable) and the same field (@NomChamp). As soon as I give other field, performance is not acceptable (25 to 30 seconds to process 240 rows).
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com