<p><font size="2" face="Verdana">Hi Nicolas</font><br>
<font size="2" face="Verdana">Thanks for your response. For further background, my QGIS table is already successfully linked to the SQL table that already has data, and the new column that I want to make logical does not yet exist in the sql table. I know that I can create a new column in QGIS and this 'pushes' the new column through to the SQL however I am not sure what datatype to pick to make the boolean possible. What would you suggest?</font><br>
<font size="2" face="Verdana">If I was creating the table directly in SQL, I would pick the bit data type, meaning it could only take 0 or 1 values, however looking at the Add Column Type drop down list, I can't see any bit provider types. Perhaps I should pick the option 1 Bytes integer as this should be compatible with the sql table. I just want to follow best practice and try to cater for future requirements on this data.</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>
<br>
<br>
<br>
<img width="16" height="16" src="http://osgeo-org.1560.x6.nabble.com/attachment/5209047/0/graycol.gif" border="0" alt="Inactive hide details for "Nicolas Cadieux [via OSGeo.org]" ---03/06/2015 10:35:05 PM---Hi, If I understand, your boolean valu"><font size="2" color="#424282" face="sans-serif">"Nicolas Cadieux [via OSGeo.org]" ---03/06/2015 10:35:05 PM---Hi, If I understand, your boolean values are in the MS SQL table? Then you will need a field</font><br>
<br>
<font size="1" color="#5F5F5F" face="sans-serif">From: </font><font size="1" face="sans-serif">"Nicolas Cadieux [via OSGeo.org]" <<a href="/user/SendEmail.jtp?type=node&node=5209047&i=0" target="_top" rel="nofollow" link="external">[hidden email]</a>></font><br>
<font size="1" color="#5F5F5F" face="sans-serif">To: </font><font size="1" face="sans-serif">Chrissie Hind <<a href="/user/SendEmail.jtp?type=node&node=5209047&i=1" target="_top" rel="nofollow" link="external">[hidden email]</a>>, </font><br>
<font size="1" color="#5F5F5F" face="sans-serif">Date: </font><font size="1" face="sans-serif">03/06/2015 10:35 PM</font><br>
<font size="1" color="#5F5F5F" face="sans-serif">Subject: </font><font size="1" face="sans-serif">Re: Logical or boolean column</font><br>
<hr width="100%" size="2" align="left" noshade style="color:#8091A5; "><br>
<br>
<br>
<font size="3" face="serif">Hi,</font>
<p><font size="3" face="serif">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.) </font>
<p><font size="3" face="serif">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>
</font><font size="3" face="serif">www.archeotec.ca</font>
<p><font size="3" face="serif">On Jun 2, 2015 9:56 PM, "CHind [via OSGeo.org]" <</font><a href="/user/SendEmail.jtp?type=node&node=5208891&i=0" target="_top" rel="nofollow" link="external"><font size="3" color="#0000FF" face="serif"><u>[hidden email]</u></font></a><font size="3" face="serif">> wrote:</font>
<ul style="padding-left: 36pt"><br>
<font size="2" face="Verdana">Hi</font><font size="3" face="serif"><br>
</font><font size="2" face="Verdana"><br>
I would like to add a new column to a linked MS SQL table within QGIS via the Layer Properties, Fields, Add column.</font><font size="3" face="serif"><br>
</font><font size="2" face="Verdana"><br>
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><font size="3" face="serif"><br>
</font><font size="2" face="Verdana"><br>
What is the best practice here?</font><font size="3" face="serif"><br>
</font><font size="2" face="Verdana"><br>
Kind Regards</font><font size="3" face="serif"><br>
<br>
</font><font size="2" color="#0000A1" face="Verdana"><b><br>
Chrissie Hind</b></font><font size="2" color="#0020C2" face="Verdana"><br>
Senior GIS Analyst</font><font size="2" face="Verdana"><u><br>
Bayside City Council</u></font>
<p><font size="2" face="Verdana">T: Â 03 9599 4792<br>
F: Â 03 9598 4474<br>
M: Â 0409 938 697</font><font size="3" face="serif"><br>
</font><font size="2" face="sans-serif"><br>
Email: Â Â <a href="/user/SendEmail.jtp?type=node&node=5208788&i=0">[hidden email]<br>
Web: Â Â Â </font><font size="2" face="sans-serif">www.bayside.vic.gov.au</font><font size="3" face="sans-serif"><br>
****************************************************************************** "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><font size="3" face="serif"> <br>
_______________________________________________ <br>
Qgis-user mailing list <br>
<a href="/user/SendEmail.jtp?type=node&node=5208788&i=1">[hidden email] </font><font size="3" color="#0000FF" face="serif"><u><br>
</u></font><a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_top" rel="nofollow" link="external"><font size="3" color="#0000FF" face="serif"><u>http://lists.osgeo.org/mailman/listinfo/qgis-user</u></font></a><font size="3" face="serif"> <br>
</font>
<p><hr width="100%" size="2" align="left" noshade><br>
<font size="3" color="#444444" face="serif"><b>If you reply to this email, your message will be added to the discussion below:</b></font><br>
<a href="http://osgeo-org.1560.x6.nabble.com/Logical-or-boolean-column-tp5208788.html" target="_top" rel="nofollow" link="external"><font size="3" color="#0000FF" face="serif"><u>http://osgeo-org.1560.x6.nabble.com/Logical-or-boolean-column-tp5208788.html</u></font></a><font size="3" color="#444444" face="serif"> </font><br>
<font size="3" color="#666666" face="serif">To start a new topic under Quantum GIS - User, email <a href="/user/SendEmail.jtp?type=node&node=5209047&i=2" target="_top" rel="nofollow" link="external">[hidden email]</a> <br>
To unsubscribe from Quantum GIS - User, <a href="</font><font size="3" color="#666666" face="serif"><a href="http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4125267&code=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYXw0MTI1MjY3fDYzNDQ4MjQxNg==">http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4125267&code=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYXw0MTI1MjY3fDYzNDQ4MjQxNg==</a></font><font size="3" color="#666666" face="serif">;">click here.<br>
<a href="</font><font size="3" color="#666666" face="serif"><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">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</a></font><font size="3" color="#666666" face="serif">" style="font:9px serif">NAML </font></ul>
<font size="3" face="serif"><br>
<br>
</font><hr width="100%" size="2" align="left" noshade style="color:#CCCCCC; "><br>
<font size="3" color="#444444" face="serif"><b>If you reply to this email, your message will be added to the discussion below:</b></font><br>
<a href="http://osgeo-org.1560.x6.nabble.com/Logical-or-boolean-column-tp5208788p5208891.html" target="_top" rel="nofollow" link="external"><font size="3" color="#0000FF" face="serif"><u>http://osgeo-org.1560.x6.nabble.com/Logical-or-boolean-column-tp5208788p5208891.html</u></font></a><font size="3" color="#444444" face="serif"> </font><br>
<font size="3" color="#666666" face="serif">To unsubscribe from Logical or boolean column, </font><a href="" target="_top" rel="nofollow" link="external"><font size="3" color="#0000FF" face="serif"><u>click here</u></font></a><font size="3" color="#666666" face="serif">.</font><font size="3" color="#0000FF" face="serif"><u><br>
</u></font><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" target="_top" rel="nofollow" link="external"><font size="3" color="#0000FF" face="serif"><u>NAML</u></font></a><font size="3" color="#666666" face="serif"> </font><br>
<br/><hr align="left" width="300" />
View this message in context: <a href="http://osgeo-org.1560.x6.nabble.com/Logical-or-boolean-column-tp5208788p5209047.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/>