General

Generalhttps://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)sql_variant datatypehttps://www.infopathdev.com:443/forums/thread/39647.aspxTue, 17 Mar 2009 23:56:08 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:39647faivre0https://www.infopathdev.com:443/forums/thread/39647.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=39647<p class="MsoNormal" style="MARGIN:0in 0in 0pt;"><font face="Times New Roman" size="3">Hello,</font></p><font face="Times New Roman" size="3"> </font> <p class="MsoNormal" style="MARGIN:0in 0in 0pt;"><font face="Times New Roman" size="3">My database design uses sql_variant.<span style="mso-spacerun:yes;">  </span>When I go to try and submit data I get the following error:</font></p><font face="Times New Roman" size="3"> </font> <p class="MsoNormal" style="MARGIN:0in 0in 0pt;"><font face="Times New Roman" size="3">Operand type clash: ntext is incompatible with sql_variant</font></p><font face="Times New Roman" size="3"> </font> <p class="MsoNormal" style="MARGIN:0in 0in 0pt;"><font face="Times New Roman" size="3">Has anyone had success using the sql_variant datatype and InfoPath?<span style="mso-spacerun:yes;">  </span>I’m using InfoPath 2007.</font></p><font face="Times New Roman" size="3"> </font> <p class="MsoNormal" style="MARGIN:0in 0in 0pt;"><font face="Times New Roman" size="3">Thanks,</font></p><font face="Times New Roman" size="3"> </font> <p class="MsoNormal" style="MARGIN:0in 0in 0pt;"><font face="Times New Roman" size="3">Brian</font></p> <p> </p>