Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Need a ISKeyword() function
Message
 
 
À
22/01/1999 13:53:13
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00179052
Message ID:
00179160
Vues:
24
>>You might be bettor off putting the keywords in a one-field table so you can add to it. NUMBER, SUM, COUNT, etc., are also bad for field names.
>
>They are not too bad as long as table aliases are using in conjunction with field names, i.e. accurate coding is even more important.

This works except when I had to use it in a UNION. Oracle refused to run a query with a field named NUMBER -- even with the table alias attached to it. Actually it was an Oracle view of a DB2 table. The DB2 table had a field named NUMBER. So we redefined the Oracle view with a SELECT NUMBER as "PWSID" ... to overcome the problem.
Mark McCasland
Midlothian, TX USA
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform