Alaska Software Inc. - Re: Foxpro and Xbase
Username: Password:
AuthorTopic: Re: Foxpro and Xbase
Andreas Gehrs-Pahl

View the complete thread for this message in:

Re: Foxpro and Xbase
on Sat, 25 Apr 2015 13:12:32 -0400
Alain,

Posting PDF files instead of text/program files is a bad idea, as it 
unnecessarily increases the length of the post, and makes it much more 
complicated to extract any of the information from those files.

To answer your main question -- as Peter Alderliesten already did in the GUI 
newsgroup -- just add the following command to your code, before you open 
the database: "Set NullValue Off". You can place that line into the DbeSys()
procedure if you want, as you probably want this to be the default behavior 
for all your databases.

I have attached a small demo program, based on your two PDF files that shows 
that this will work. Just remark out the "NullValue" line in the DbeSys() 
procedure, and you will get the same error(s) as you reported.

Hope that helps,

Andreas

Andreas Gehrs-Pahl
Absolute Software, LLC

phone: (989) 723-9927
email: Andreas.GP@Charter.net
web:   http://www.Aerospace-History.net

Fox_Null.zip