Alpha Video Training
Results 1 to 2 of 2

Thread: Not Null Columns in SQL Server

  1. #1
    Member njguy's Avatar
    Real Name
    Tom Ritter
    Join Date
    Nov 2009
    Location
    New Jersey
    Posts
    289

    Default Not Null Columns in SQL Server

    I have columns defined as being Not Null in SQL Server 2008 but when I enter data in a detail view I can save the data with these columns being Null. I am new to SQL Server so I don't know if I am missing a setting on that side or Alpha's side

  2. #2
    Member njguy's Avatar
    Real Name
    Tom Ritter
    Join Date
    Nov 2009
    Location
    New Jersey
    Posts
    289

    Default Re: Not Null Columns in SQL Server

    After searching through all the options I found the "Blank is NULL" option on the Field Properties window not checked.

    In the System Default Property Values the setting for detailview.blank_is_null = .t. but it is not checked on when you create a new detail view. Is there a different property for this field?

Similar Threads

  1. Force null on numeric SQL insert
    By jim_s in forum Alpha Five Version 10 - Desktop Applications
    Replies: 4
    Last Post: 04-25-2010, 12:33 AM
  2. Date update from null (SQL)
    By GarthMc in forum Application Server Version 10 - Web/Browser Applications
    Replies: 1
    Last Post: 10-10-2009, 05:18 PM
  3. SQL Calculated Columns
    By ThemBoots in forum Application Server Version 9 - Web/Browser Applications
    Replies: 1
    Last Post: 02-06-2009, 09:46 AM
  4. Can A5V9 sort on columns with SQL data without breaking?
    By Fulltimer in forum Application Server Version 9 - Web/Browser Applications
    Replies: 1
    Last Post: 08-22-2008, 09:07 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •