https://kb.sagedev.it/index.php?action=history&feed=atom&title=Istruzioni_SQL 2026-04-30T16:17:01Z Revision history for this page on the wiki MediaWiki 1.35.1 https://kb.sagedev.it/index.php?title=Istruzioni_SQL&diff=1123&oldid=prev 2026-03-24T12:21:59Z

<p></p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 12:21, 24 March 2026</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l6" >Line 6:</td> <td colspan="2" class="diff-lineno">Line 6:</td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Local Char WREQ(255) : WREQ=&quot;&quot;  </div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Local Char WREQ(255) : WREQ=&quot;&quot;  </div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">WSEQ </del>= &quot;SELECT ITMREF_0, ITMDES1_0 FROM SAGEDEV.ITMMASTER WHERE ITMREF_0 LIKE 'WER%'&quot;  </div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">WREQ </ins>= &quot;SELECT ITMREF_0, ITMDES1_0 FROM SAGEDEV.ITMMASTER WHERE ITMREF_0 LIKE 'WER%'&quot;  </div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>For (Char ITM(20), Char DES(40)) From &quot;5&quot; Sql WREQ As [REQ_]</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>For (Char ITM(20), Char DES(40)) From &quot;5&quot; Sql WREQ As [REQ_]</div></td></tr> </table>

217.194.179.250 https://kb.sagedev.it/index.php?title=Istruzioni_SQL&diff=65&oldid=prev 2019-05-31T08:36:11Z

<p>Created page with &quot; Codice di esempio per eseguire una query nel database di Sage: &lt;pre&gt; Local Char WBASE : WBASE=&quot;5&quot; Local Char WREQ(255) : WREQ=&quot;&quot; WSEQ = &quot;SELECT ITMREF_0, ITMDES1_0 FROM...&quot;</p> <p><b>New page</b></p><div><br /> Codice di esempio per eseguire una query nel database di Sage:<br /> <br /> &lt;pre&gt;<br /> Local Char WBASE : WBASE=&quot;5&quot;<br /> Local Char WREQ(255) : WREQ=&quot;&quot; <br /> <br /> WSEQ = &quot;SELECT ITMREF_0, ITMDES1_0 FROM SAGEDEV.ITMMASTER WHERE ITMREF_0 LIKE 'WER%'&quot; <br /> <br /> For (Char ITM(20), Char DES(40)) From &quot;5&quot; Sql WREQ As [REQ_]<br /> Infbox ITM - DES <br /> Next<br /> &lt;/pre&gt;<br /> <br /> <br /> Se si vuole automatizzare la scelta del dbms:<br /> &lt;pre&gt;<br /> Case GTYPDBA<br /> When 1 : WBASE = &quot;3&quot; : # Oracle<br /> When 2 : WBASE = &quot;5&quot; : # Sql<br /> When 3 : WBASE = &quot;2&quot; : # Cisam<br /> When 4 : WBASE = &quot;4&quot; : # DB2<br /> Endcase<br /> <br /> For (Char ITM(20), Char DES(40)) From WBASE Sql WREQ As [REQ_]<br /> Infbox ITM - DES <br /> Next<br /> <br /> &lt;/pre&gt;</div>

Mwadmin