I was written in pb6.5 + sybase server 11.9.2 program, at the time of data entry, some character field if there is no data, in order not to let it is empty, I'll let it keep an empty artificially character "", the program runs fine, but on one occasion, server problems, reshipment database, I put through the save as backup data into the database, but that the original preservation becomes empty, empty character data program runs out of the question, I'll use the following SQL language to empty data as a null character, crashes as a result, the title bar" no response "move the mouse, how can I solve. Thank you
The update table name set field 1='where 1 is null field;
The update table name set field 2=2 'where field is null;
. .