[RBG7-L] - RE: Null character

[Charles Parks]

It might be worth unloading the database and reloading it.   I unload the structure to one file split it at the view statements. Unload data.   Run strucuture1 file Run data trace structure 2 file and make a note of what it thinks is wrong. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Joel Solomon Posted At: Friday, August 06, 2004 3:03 PM Posted To: RB7-L Conversation: [RBG7-L] - RE: Null character Subject: [RBG7-L] - RE: Null character I tried that and only the real nulls react.  The others ignore it ----- Original Message ----- From: Charles Parks To: RBG7-L Mailing List Sent: Friday, August 06, 2004 4:52 PM Subject: [RBG7-L] - RE: Null character Type show null at the R>   If does not return this:   NULL symbol     -0-   Type set null -0- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Joel Solomon Posted At: Friday, August 06, 2004 2:45 PM Posted To: RB7-L Conversation: [RBG7-L] - Null character Subject: [RBG7-L] - Null character I know its late on Friday, but this is really got me stumped.   I have data that looks like a null (-0-) but does not act like a null.   In some of my fields the null appears and when I set null to a blank the field is blank (works correctly).  But, in other fields the field has a -0- that does not act as a null.  It left justifies itself and is recognizable as a null.   The only difference is that the data with the funny null came from a laptop computer and the data was later appended to the master table.  Both were entered into a form.   Am I going crazy??   Joel Solomon Controller Barbizon International [EMAIL PROTECTED] Ph:    954-345-4140  ext. 203 Fax:   954-345-8055