Dick, Why don't you see if you can look up the blank data using a literal null in your where clause (where colname1 = ' ')
Steve Vellella Office: 520-498-2256 Cell: 520-250-6498 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dick Fey Sent: Thursday, April 22, 2010 12: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.
