If I press completion key Intellisense shows NULLIF() instead of NULL.
There is no NULL in list candidates and I do not know how to add it except as snippet.
I've noticed this problem for a long time as well. It would be nice to get NULL into the list of candidates. To expand upon the above post, NULL seems to never appear in the list, no matter what situation. In particular, I generally use something like this:
...
WHERE
[Field] IS NULL
And NULL is not in the candidate list. However, it does get capitalized automatically if I choose to press Space, which is NOT a completion key for me. So Prompt is recognizing it as a reserved keyword, just not as a potential candidate. This is a usability problem because if I choose to use a completion key, it will insert NULLIF() or some other (invalid) candidate. Thanks.
Jeremy Fuller
VP, Software Development
Organizational Intelligence, Inc.
Ivailo Vratchanski
Posts: 8
Comments
...
WHERE
[Field] IS NULL
And NULL is not in the candidate list. However, it does get capitalized automatically if I choose to press Space, which is NOT a completion key for me. So Prompt is recognizing it as a reserved keyword, just not as a potential candidate. This is a usability problem because if I choose to use a completion key, it will insert NULLIF() or some other (invalid) candidate. Thanks.
VP, Software Development
Organizational Intelligence, Inc.