Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
YEAR is not unique and must be qualified
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
YEAR is not unique and must be qualified
Divers
Thread ID:
00272291
Message ID:
00272291
Vues:
102
YEAR is not unique and must be qualified.

I get the above error msg when running the following code...
SELECT ;
  A.Invoice, ;
  ShipDate, ;
  Oslsm, ;
  Prodct, ;
  Cust, ;
  QtyOrd, ;
  Oprice, ;
  QtyUpd, ;
  Ocompc, ;
  A.ShipDue, ;
  Terr, ;
  WrHse, ;
  Scity, ;
  Sstate, ;
  A.Year, ;
  A.Month ;
FROM ;
  OrdrDtlH A, OrdrHdrH ;
INTO TABLE ShipHst ;
WHERE ;
  A.Invoice = OrdrHdrH.Invoice .AND. ;
  Year = '1999' .AND. ;
  Month = '12'
Yes, even though it seems odd, Year and Month are Character fields.
Haven't been able to resolve problem. Would appreciate any help. TIA, Chuck
Chuck Henry
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform