Why the forth column? If it is empty always just add the column after the load.
I assume you already checked the Db? Completely! If rows are -0- there must be something in the text that is being imported. Is it possible to clean it up by bringing in to a 'temp table' first. Are you able to use a viewer to view ALL chars in this file that you are loading or is it perhaps a xml type file? In the delete script any possible why to verify null? And/or set null = -0- then use '=' if you haven't already done this. :) Last unload the table and check what is in there. Does it happen also in a clean/new DB just to test? Sincerely, Paul Dewey -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dick Fey Sent: Thursday, April 22, 2010 3:47 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Unusual Null behavior Using 7.5 I am importing a table of colors into the database using the Load command. Four columns, 3 contain data, 1 is empty. Sometimes a blank row will import. With Null set to -0-, only the column with no data shows the null in the blank row. The columns containing data display a blank field in that row. You can delete the row manually, but not using a delete command, because the only field that appears to be null is the column in which all rows are null. Thus if you use that column to delete on, all rows are deleted. Ah the mysteries of life. How about it genuis's... what is happening? Dick Fey Carpet Broker Inc.
