Appended Varbinary Data to a SQL Database Showing up As Null

Updated Mar 12, 2018

Reported In

Software

  • LabVIEW
  • LabVIEW Base
  • LabVIEW Full
  • LabVIEW Professional
  • LabVIEW Database Connectivity Toolkit

Issue Details

I am trying to append a column of varbinary data to an existing table in a SQL database. Every write function to the table has worked in the past, but now that I am using the DB Tools Insert Data VI to add an additional column, the new data in the appended column comes in as NULL.

Solution

Ensure that the database table has all necessary fields defined when creating the table. Trying to append a column/field of data to the table at a later time could cause this type of behavior.

WAS THIS ARTICLE HELPFUL?

Not Helpful