Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
>One problem with this approach is if you add even one Contact type, you have to add a column to your main SELECT. Then you have to remember to add another Contact column in your report.
Unless you start off by selecting all the different distinct contact types and build the rest from there. If you want to get really fancy you can also find out the max number of repeating line info (like the person with 4 cell phones) in advance an work from that info. Then you will have overflows on some printers, so arguing to write out such a list into excel is the appropriate way - But in most projects there is not enough time to do everything in a more generic way<g>.
regards
thomas
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