Information générale
Catégorie:
Codage, syntaxe et commandes
>My table and view all have columns labeled "pat_id", "mom_id", "hosp_id". By (inadvertently) naming my parameters with the exact same labels as the source data columns (which you wouldn't have known since I had not included that info in my original post here), the query becomes ambiguous ~
Been there, done that, or something like it. The command where I always seem to bump into that is INSERT INTO.
FWIW, this is one of the arguments for a naming convention that distinguishes variables from fields.
Tamar
Précédent
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