<p dir="ltr">Hi,</p>
<p dir="ltr">If I understand, your boolean values are in the MS SQL table? Then you will need a field with unique values (integers are simpler) in both the QGIS table and the external table in order to link both tables. If you can't use integers, you could use another type but this field needs to be unique (therefore if you use a family name, you are likely to have two identical names.) </p>
<p dir="ltr">Nicolas Cadieux M.Sc.<br>
Les Entreprises Archéotec inc. <br>
8548, rue Saint-Denis Montréal H2P 2H2<br>
Téléphone: 514.381.5112 Fax: 514.381.4995<br>
www.archeotec.ca</p>
<div class="gmail_quote">On Jun 2, 2015 9:56 PM, "CHind [via OSGeo.org]" <<a href="/user/SendEmail.jtp?type=node&node=5208891&i=0" target="_top" rel="nofollow" link="external">[hidden email]</a>> wrote:<br type='attribution'><blockquote style='border-left:2px solid #CCCCCC;padding:0 1em' class="quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<p><font size="2" face="Verdana">Hi</font><br /><br /><font size="2" face="Verdana">I would like to add a new column to a linked MS SQL table within QGIS via the Layer Properties, Fields, Add column.</font><br /><br /><font size="2" face="Verdana">I am not sure what option to use within the Type to select as I only want to retain boolean values or either 0 or 1, Y or N, or T or F.</font><br /><br /><font size="2" face="Verdana">What is the best practice here?</font><br /><br /><font size="2" face="Verdana">Kind Regards</font><br /><br /><br /><font size="2" color="#0000A1" face="Verdana"><b>Chrissie Hind</b></font><br /><font size="2" color="#0020C2" face="Verdana">Senior GIS Analyst</font><br /><font size="2" face="Verdana"><u>Bayside City Council</u></font><br />
</p><p><font size="2" face="Verdana">T: 03 9599 4792</font><br /><font size="2" face="Verdana">F: 03 9598 4474</font><br /><font size="2" face="Verdana">M: 0409 938 697</font><br /><br /><font size="2" face="sans-serif">Email: <a href="/user/SendEmail.jtp?type=node&node=5208788&i=0">[hidden email]</a></font><br /><font size="2" face="sans-serif">Web: www.bayside.vic.gov.au</font><br /><font face="sans-serif">******************************************************************************
"Please consider the environment before you print this email."
This email, including all attachments, is confidential. Any personal or
sensitive information contained in this email and attachments must be
handled in accordance with the Victorian Information Privacy Act 2000 and
the Health Records Act 2001. If you are not the intended recipient, you
must not disclose, distribute, copy or use the information contained in
this email or attachments. Any confidentiality or privilege is not waived
or lost because this email has been sent to you in error. If you have
received it in error, please advise the sender by return email, delete it
from your system and destroy any copies. The sender gives no warranty that
any attachments to this email are free from viruses or other defects.
********************************************************************************</font>
<br />_______________________________________________
<br />Qgis-user mailing list
<br /><a href="/user/SendEmail.jtp?type=node&node=5208788&i=1">[hidden email]</a>
<br /><a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_top" rel="nofollow" link="external">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
<br />
<br />
</p><hr noshade="noshade" size="1" />
<div style="color:#444;font:12px 'tahoma' , 'geneva' , 'helvetica' , 'arial' , sans-serif">
<div style="font-weight:bold">If you reply to this email, your message will be added to the discussion below:</div>
<a href="http://osgeo-org.1560.x6.nabble.com/Logical-or-boolean-column-tp5208788.html" target="_top" rel="nofollow" link="external">http://osgeo-org.1560.x6.nabble.com/Logical-or-boolean-column-tp5208788.html</a>
</div>
<div style="color:#666;font:11px 'tahoma' , 'geneva' , 'helvetica' , 'arial' , sans-serif;margin-top:0.4em;line-height:1.5em">
To start a new topic under Quantum GIS - User, email ml-node+s1560n4125267h38@n6.nabble.com <br />
To unsubscribe from Quantum GIS - User, <a href="http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4125267&code=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYXw0MTI1MjY3fDYzNDQ4MjQxNg==">click here</a>.<br />
<a href="http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml" style="font:9px serif">NAML</a>
</div></blockquote></div>
<br/><hr align="left" width="300" />
View this message in context: <a href="http://osgeo-org.1560.x6.nabble.com/Logical-or-boolean-column-tp5208788p5208891.html">Re: Logical or boolean column</a><br/>
Sent from the <a href="http://osgeo-org.1560.x6.nabble.com/Quantum-GIS-User-f4125267.html">Quantum GIS - User mailing list archive</a> at Nabble.com.<br/>