Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need a ISKeyword() function
Message
 
 
To
22/01/1999 13:53:13
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00179052
Message ID:
00179160
Views:
23
>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform