John W. Colby
jcolby at colbyconsulting.com
Thu Feb 27 06:45:21 CST 2003
In addition, I just went into table design inside the ADP and no default value is shown, whereas in the EM a value of (1) is shown (it is a bit field in SQL Server). Strange eh? John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com]On Behalf Of John W. Colby Sent: Thursday, February 27, 2003 7:41 AM To: AccessD Cc: AccessD-SQLServer Subject: [AccessD] 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 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ---------------------------------------------------- Is email taking over your day? Manage your time with eMailBoss. Try it free! http://www.eMailBoss.com -------------- next part -------------- A non-text attachment was scrubbed... Name: winmail.dat Type: application/ms-tnef Size: 2220 bytes Desc: not available URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030227/9773bfa0/attachment-0001.bin>