(Sorry, big Oscar Wilde fan...) Just a reminder to people, especially the newbies to RBase, of how important your NULL setting can be. Working on a client's test environment, needed to refresh some tables with data from the live database. On the live database, the null setting was -0-. I did an "unload as ascii". I connected my test database, and loaded the data. Now my test program seemed to work incorrectly, spent quite a bit of time debugging my code.... Turns out that my null setting was a blank in the test environment. So when I loaded in from the ascii file, it loaded any null -0- into text columns as a literal '-0-'. My program code was looking where this column was null, and it wasn't finding any!
Since I did the unload "as ascii", there are no settings built into the file. That was the big problem with the mismatch of null settings. Karen
