Dick, I assume you are trying to get rid of the blank rows with programming as opposed to manually deleting them.
If the suggestions to locate the problem in your import files don't help then try and find a way to clean it up after the fact. If your colors are a finite list then use that list in a "not in" clause to delete or "in" clause to append the good data to another table or use a "SLEN" clause where (slen(colname1)) >= 1 or some length that makes sense to append/project the good data. Steve 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 1:21 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Unusual Null behavior Tried that too... You can do a delete where count = 1, but you can't test for anything because the nulls do not show up. Dick Steve Vellella wrote: > 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. > > > > >
