Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
INDEX does not accept NULL
Message
 
 
To
10/10/2001 14:24:30
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00566579
Message ID:
00566581
Views:
12
>I have a parameterized view which I then index on:
>
>INDEX ON v_ViewName.cFieldName TAG cFieldName [Character field]
>and
>INDEX ON v_ViewName.dFieldName TAG dFieldName [DateTime field].
>
>I get the subject error message 'INDEX does not accept NULL'. I find no reference in the documentation, Hacker's Guide, or FoxWiki.
>
>How could I resolve this isssue other than changing the view to substitute blanks / empty DateTime?

From VFP 7 help: "Index does not accept NULL (Error 1886)
Your primary or candidate key index expression evaluated to NULL, which is an invalid value for these types of indexes.
Change record values so the expression does not evaluate to NULL".

You can use NVL() function to convrt Null to some other value in the view or in the index expression.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform