I added a field of type Tinyint (which will be used as logical .T./.F. in VFP app) to an existing table. When I retrieve a bunch of records, all existing records have value .T.. In SQL Server table they are all .NULL. I am thinking about deleting this field and entering it again to make all existing records to be value .F.. How would I do it? That is, when I add a new field to the SQL Server table, what should I do to make the existing fields 0 and not .NULL.?
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham