check for NULL column in SQL datasource - InfoPath Dev
in

InfoPath Dev

check for NULL column in SQL datasource

Last post 05-05-2012 10:35 AM by Jimmy. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 05-04-2012 07:30 AM

    check for NULL column in SQL datasource

    Hello

      I am trying to figure out a sure fire way to check to see if a column is NULL in a SQL datasource.

  • 05-05-2012 10:35 AM In reply to

    Re: check for NULL column in SQL datasource

    As far as I can tell, SQL data sources do not distinguish between NULL and blank values.  Both are simply blank in the XML data.

    The QueryDB web service that's part of DBXL does allow drawing this distinction: null values are returned with an xsi:nil attribute in the XML, while blank values are simply blank, without an xsi:nil attribute. Switching to QueryDB would probably be overkill for just this one feature, but on the other hand, QueryDB does offer several benefits compared to SQL data connections.

    Jimmy Rishe / Software Developer / Microsoft MVP
    Qdabra Software
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.