Hola ... como puedo obtener la cantidad de columnas de una tabla?<div><br></div><div>hice lo siguiente de modo rudimentario pero seguramente existe una forma mucho mas directa ... alguna pista?</div><div><br></div><div><br>
</div><div><span class="Apple-style-span" style="font-family: 'Helvetica Neue', Helvetica, Arial, Geneva, 'MS Sans Serif', sans-serif; font-size: 13px; color: rgb(17, 0, 0); "><pre class="python" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0.8em; padding-right: 0.8em; padding-bottom: 0.8em; padding-left: 0.8em; font-family: monospace; overflow-x: visible; overflow-y: visible; white-space: pre; font-size: 12px; background-color: rgb(255, 255, 255); width: auto; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-color: rgb(221, 221, 221); border-right-color: rgb(221, 221, 221); border-bottom-color: rgb(221, 221, 221); border-left-color: rgb(221, 221, 221); clear: none; line-height: 1.333; ">
orden = <span style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, Geneva, 'MS Sans Serif', sans-serif; color: rgb(72, 61, 139); ">'SELECT * FROM nombretabla WHERE id = 1'</span>
cursor.<span style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, Geneva, 'MS Sans Serif', sans-serif; color: black; ">execute</span><span style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, Geneva, 'MS Sans Serif', sans-serif; color: black; ">(</span>orden<span style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, Geneva, 'MS Sans Serif', sans-serif; color: black; ">)</span>
<span style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, Geneva, 'MS Sans Serif', sans-serif; color: rgb(255, 119, 0); font-weight: bold; ">for</span> objeto <span style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, Geneva, 'MS Sans Serif', sans-serif; color: rgb(255, 119, 0); font-weight: bold; ">in</span> cursor:
valor = <span style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, Geneva, 'MS Sans Serif', sans-serif; color: rgb(0, 128, 0); ">len</span><span style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, Geneva, 'MS Sans Serif', sans-serif; color: black; ">(</span>objeto<span style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, Geneva, 'MS Sans Serif', sans-serif; color: black; ">)</span>-<span style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, Geneva, 'MS Sans Serif', sans-serif; color: rgb(255, 69, 0); ">1</span></pre>
</span></div>