Thank you Jim and Bob.
Paul
On Mar 20, 2009, at 9:35 AM, Bob Sneidar wrote:
Also, I have a rule when designing SQL databases: NO NULLS! I
always use empty strings as the default value for a text field and
0 as the default for number fields.
Bob Sneidar
IT Manager
Logos Management
Calvary Chapel CM
On Mar 20, 2009, at 9:27 AM, Jim Ault wrote:
When using the filter command and foreign data I always replace null
with empty (or space, depending). Hypercard used '00' to be the end
char of strings in its stack structure. In the days of recovering
from hard drive corruption, I did many scans in hex for stack data
recovery.
Some systems will add a null to web pages and since they are ignored
by browsers, no worries until you capture and try to work with the
characters.
Jim Ault
Las Vegas
On Mar 20, 2009, at 8:42 AM, Paul Looney wrote:
Richard,
Thanks for the insight.
Most of this archived data had been imported from the previous
HyperCard system. We've now done many such imports and this is the
only customer with this problem.
Another customer, at the other end of the country, had a different
problem; blank spaces in fields. For example, the description field
might have 25 lines; lines 1 to 4 were correct, lines 5 to 9 were
missing, and lines 10 to 25 were correct. The "hole" was not always
in the same fields or the same lines. We traced this back to them
using AppleWorks and MS Word to write notes - which they had then
pasted into the notes field on the HC-based program.
We occasionally get a NULL in the current, Rev-based, system (about
one in six months). We have checked the code but not found a source.
Obviously the user can not type a NULL.
I will vote for both 7823 and, especially 7824.
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
