Wortz, Charles
CWortz at tea.state.tx.us
Thu Feb 27 13:00:02 CST 2003
Normally I get messages posted to both these list at the same time. Today there is an almost six hour lag between the two. If others are experiencing the same lag between the two lists, you may get some late responses. Charles Wortz Software Development Division Texas Education Agency 1701 N. Congress Ave Austin, TX 78701-1494 512-463-9493 CWortz at tea.state.tx.us -----Original Message----- From: John W. Colby [mailto:jcolby at colbyconsulting.com] Sent: Thursday 2003 Feb 27 06:41 To: AccessD Cc: AccessD-SQLServer Subject: [AccessD] [dba-SQLServer]SQL Server default value not happening I upsized my client billing to SQL Server the other day. This morning I noticed that a couple of flag fields in my main time table are not being set to their default value. I went directly into EM and created a record in the table and the flags are correctly set there. I opened the ADP, opened the table there and entered a record, and the default value is NOT being set correctly there. Any ideas why the default values would work in EM but not in the ADP? John W. Colby Colby Consulting www.ColbyConsulting.com ---------------------------------------------------- Is email taking over your day? Manage your time with eMailBoss. Try it free! http://www.eMailBoss.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com