>>>I'm using a view from an access database, I would like to get rid of all records with a .null. value on a certain field.
>>>
>>>How do I separate the records with .null. values, I've tried several different >
>>Have you used the ISNULL function?
>
>hullo,
>
>let me guess. on that field, the default value is null? is it indexed? can you
try 'set order to
descending' so that the records with .null.
surface? (will it work, rostand) if so, you can go top, isnull() (hey dan is right) if .t. then delete, and then skip.
>
>just testing... :)
please make it 'set order to ascending' so that they surface. i just tested it even without default value of null (i replaced a record with .null.) it works.
rostand
"le rêve d'étoiles" - (Fr.) the dream of the stars Ü