Charlotte Foust
charlotte.foust at gmail.com
Tue Dec 14 11:01:11 CST 2010
It matters if you refer to them in SQL in code and then switch to a SQL Server BE. Better to be safe than sorry. Charlotte Foust On Mon, Dec 13, 2010 at 1:06 PM, Stuart McLachlan <stuart at lexacorp.com.pg> wrote: > It doesn't matter. > > True/False and Yes/No as predefined numeric equated for the values -1 and 0. > Effectively they are all the same thing. > > -- > Stuart > > On 13 Dec 2010 at 11:27, Dan Waters wrote: > >> I want to set my Yes/No fields to a default value to avoid the problem >> with a Null value. If my Yes/No fields are bound to a control, it's >> always a checkbox. >> >> >> >> Should I use True/False, Yes/No, or -1/0? Or does it matter? >> >> >> >> Thanks! >> >> Dan >> >> >> >> >> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >> > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >