Create Table Name (firstname char(10) not null, surname char(10) not null) creates a table that has a 20 byte record and does not allow nulls from the ODBC interface for me. If you've got other fields and they do not have the NOT NULL keywords and do not have the True Null Byte Indicator, then the record structure could be off.
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.