Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
TABLEUPDATE fails with Syntax Error
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00260654
Message ID:
00261085
Vues:
20
I finally figured it out. The tables have a field named DESC, for the Description. I also have an index on that field ...

INDEX ON UPPER(DESC) TAG DESC

Unfortunately, DESC is the 4-character abbreviation for DESCENDING so FoxPro was interpreting the index as ...

INDEX ON UPPER(DESC) TAG [no-name] DESCENDING

This one cost me several days of scratching my head, pounding my fist on my desk and a few (okay, more than a few) swear words along the way <s>.

BTW, thanks for the eview download ... This will come in handy.
Cathy Pountney, Microsoft Visual FoxPro MVP
Memorial Business Systems, Inc. (www.mbs-intl.com)

My Website: (www.frontier2000.com)
My Blog: (www.cathypountney.blogspot.com)
My Book: The Visual FoxPro Report Writer - Pushing it to the Limit and Beyond
Free MSDN Article: What's New in the VFP 9.0 Report Writer
Free MSDN Article: The VFP 9.0 Report Writer In Action
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform