<div>
instead of building the query like that, use odbcparameter:<br />
<a href="http://msdn.microsoft.com/en-us/library/system.data.odbc.odbcparameter.aspx" rel="ugc nofollow">http://msdn.microsoft.com/en-us/library/system.data.odbc.odbcparameter.aspx</a>
</div>


instead of building the query like that, use odbcparameter:
http://msdn.microsoft.com/en-us/library/system.data.odbc.odbcparameter.aspx [http://msdn.microsoft.com/en-us/library/system.data.odbc.odbcparameter.aspx]

<div>
<div class="content wysiwyg-content">
Dim selectCMD As Odbc.OdbcCommand = New Odbc.OdbcCommand(&quot;SELECT M$EMIT FROM KSEDTALIB.M$MEMP WHERE M$EMID = &quot;&nbsp;&amp; Engine &amp;&nbsp;&quot;&quot;, MyODBCConnection)<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; 'Initialize the reader<br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim dr As Odbc.OdbcDataReader = selectCMD.ExecuteReader<br />
<br />
when I change WHERE M$EMID = 'FXT00VA00097' it works and selects the right statement<br />
<br />
but when I define Engine = &quot;FXT00VA00097&quot; and put WHERE M$EMID = &quot;&nbsp;&amp; Engine &amp;&nbsp;&quot;&quot;, <br />
<br />
it gives the error<br />
ERROR [42S22][IBM][iSeries Access ODBC Driver][DB2 UDB]SQL 0206 - Column FXT00VA00097<br />
not in specified tables<br />
<br />
I have to use a variable for the data selection. any help would be appreciated.
</div>
</div>


Dim selectCMD As Odbc.OdbcCommand = New Odbc.OdbcCommand("SELECT M$EMIT FROM KSEDTALIB.M$MEMP WHERE M$EMID = " & Engine & "", MyODBCConnection)

        'Initialize the reader
        Dim dr As Odbc.OdbcDataReader = selectCMD.ExecuteReader

when I change WHERE M$EMID = 'FXT00VA00097' it works and selects the right statement

but when I define Engine = "FXT00VA00097" and put WHERE M$EMID = " & Engine & "", 

it gives the error
ERROR [42S22][IBM][iSeries Access ODBC Driver][DB2 UDB]SQL 0206 - Column FXT00VA00097
not in specified tables

I have to use a variable for the data selection. any help would be appreciated.

error on sql selection from as400 using visual basic

IBM i, formerly known as AS/400, is a proprietary, midrange, object-based operating and application system. It includes a relational database, a menu-driven interface, support for multiple users, block-oriented terminal support and printers, and supports security, communications, and web-based application servers including Websphere, Apache and Tomcat.

IBM System i

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.