Arthur Fuller
artful at rogers.com
Thu Feb 27 08:44:26 CST 2003
1. I just created a SQL table with 4 columns, 3 of them defaulted. 2. I can see the column defaults fine in my ADP (this is A2002). 3. I created an AutoForm to talk to the table, and I see the defaults there right away when I add a new row. 4. One thing I noticed. My columns are set to NOT NULL. That may make a difference, but if there is a default value then why would you want to permit NULLs? -----Original Message----- From: dba-sqlserver-admin at databaseadvisors.com [mailto:dba-sqlserver-admin at databaseadvisors.com] Sent: February 27, 2003 9:18 AM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer]SQL Server default value not happening No, I understand that. It is NOT being set AT ALL in the created record from inside the ADP. That's how I discovered it wasn't being set. This case is my active flag which must be set to see records. Three records created yesterday were mysteriously missing. The answer... the active flag is not being set true by default when the record is created. Further, IN DESIGN VIEW in the ADP, the default value doesn't show. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: dba-sqlserver-admin at databaseadvisors.com [mailto:dba-sqlserver-admin at databaseadvisors.com]On Behalf Of Arthur Fuller Sent: Thursday, February 27, 2003 9:09 AM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer]SQL Server default value not happening I assume that you mean the SQL level default value rather than the Access level default. If so, I don't think you'll see it set until after you save the row. Same behaviour as ANPK values. -----Original Message----- From: dba-sqlserver-admin at databaseadvisors.com [mailto:dba-sqlserver-admin at databaseadvisors.com] On Behalf Of John W. Colby Sent: February 27, 2003 7:41 AM To: AccessD Cc: AccessD-SQLServer Subject: [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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver 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: 5744 bytes Desc: not available URL: <http://databaseadvisors.com/pipermail/dba-sqlserver/attachments/20030227/50ecadf1/attachment.bin>