Information générale
Catégorie:
Codage, syntaxe et commandes
Thank you,
We are going to give this a try
where ccust in ("03118","03335","03770")
Your assumptions are correct. We have a form with a combo box and a mover control. The Combo box determins whether the user wants Custid, CustName, CustState etc. The Mover lets the user select items from each option. So this SQL could get quite large. My argument to my team here is that if the user selects 100 customers, they are doing something wrong. Those 100 customers must have something else in common that could be used as the filter. But your suggestion will make our final SQL code smaller.
Jeremy Weidig
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