| Title: | FOCUS, from INFORMATION BUILDERS |
| Moderator: | ZAYIUS::BROUILLETTE |
| Created: | Thu Feb 19 1987 |
| Last Modified: | Mon May 05 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 615 |
| Total number of notes: | 1779 |
Handly Gardening tips to FOCUS users No. 1.
--------------------------------------------
Just a little pointer to help all you happy Focus users out there
in Digi-land.
DONT Ever Ever Ever use a field name starting with ALL in a
JOIN statement. Why? Because (Unless you very lucky or have
a badge number with only 1 digit) you'll get an error message.
The reason is that Focus will use the first three character as the
ALL command.
ie
file 'A' has a field named 'GREEN_SLIME'
file 'B' has a field named 'ALLOW_KEY'
if you try this : ->
JOIN GREEN_SLIME IN A TO ALLOW_KEY IN B AS J1
Focus will read it as : ->
JOIN GREEN_SLIME IN A TO ALL OW_KEY IN B AS J1
OW_KEY Doesn't exist, hense error. Q.E.D.
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 194.1 | YUCK!!!!!! | PICV03::STRONBERG | Wed Apr 05 1989 08:30 | 4 | |
In a word, YUCK!!!!!
Not to mention, nasty......
| |||||