I have a departments table, and when I open it in browse mode, and type the following:

BROWSE FOR vehdept = 'PATROL'

It pulls up a single record, which has .NULL. in the vehdept field. There are other records with .NULL. in that field, but it only pulls up this one. ? IsnNull(VehDept) returns .t., so it's not a case of a string ".NULL." (Which shouldn't match either.)

If the record doesn't appear with

BROWSE FOR vehdept = 'PATROL' NOOPTIMIZE

then it's a corrupt index file.

That wouldn't happen to be the current record when you do the browse, would it? On Jun 13, 2016 11:13 AM, "Vince Teachout" teachv@taconic.net wrote:

I have a departments table, and when I open it in browse mode, and type the following:

BROWSE FOR vehdept = 'PATROL'

It pulls up a single record, which has .NULL. in the vehdept field. There are other records with .NULL. in that field, but it only pulls up this one. ? IsnNull(VehDept) returns .t., so it's not a case of a string ".NULL." (Which shouldn't match either.)

Luckily, this isn't anything I was actually working on, just something I came across while trying to transfer data. But.... any ideas what could cause this?

[excessive quoting removed by server]