Hi,

I'm working under VFP8.0(SP1)

There is a table:
create table ("vehicles.dbf") name "vehicles_t"(;
vehicle_id i not null,;
vehicle_code c(8) not null,;
primary key vehicle_id tag "id")

and a view on this table:
Create SQL View VEHICLE_R AS ;
SELECT ;
VEHICLES_T.VEHICLE_ID,;
VEHICLES_T.VEHICLE_CODE,;
FROM VEHICLES_T;
WHERE VEHICLES_T.VEHICLE_ID = ?G_VEHICLE_ID

An attempt to open the view

G_VEHICLE_ID = .null.
use VEHICLE_R

or execute SELECT a statement

select * from vehicles_t where vehicle_id = .null.

raises an error Index does not accept NULL (Error 1886)


Statement
select * from vehicles_t where vehicle_id is null
works fine

It is not clear for me what is a cause of the error.

Thank you.