Sql bit to Yes/No not working


Badge +1

I'm using 4.6.9 and I'm having a problem with getting data from the db. It works fine when I use all data labels except for a sql bit field. When I use the checkbox everything is blank that is associated with the db. When I use a text box it fills in a false but no other fields come back. When I use a data label, all data label fields are populated but the bit fields are not even if using a data label. Any help would be appreciated....thanks!


2 replies

Userlevel 5
Badge +16

Dear,

 

Can you please attach an image of you smartobject properties? 

 

regards,

 

Badge +1

I got it. There was some data missing from one of the tables being used by the view so no data was available for checkboxes. Thanks!

Reply