Does anyone handle blank values in Construct?

DSP User

• August 17, 2017 07:11

Does anyone handle blank (no null, no dummy value, no space) values in Construct? Is it possible somehow (without using SP or similar) to insert a blank value in a field in Construct (via interface and Excel)? Unfortunately our client needs it as a valid value (even for a PK). We are using DSP 6.6 Thanks.

1

• Best answer

  

  DSP Expert

  • August 18, 2017 09:50

  TGhinder: A zero length string inserted via file-based interfaces would be exactly the same as a null. If the client needs a blank in a field instead of null, change the default value in the table to a zero length string. With that change, I believe all inserted records with nothing provided should end up with a zero length string value instead of null.

  0

Please sign in to leave a comment.