1 appears to work. I have the fourth field defined as a byte.
The text file contents:
<pre>
Field1,Field2,Field3,1
this,is,a,0
this2,is2,a2,0
this3,is3,a3,1
</pre>
The sample code:
<code>
import java.sql.*;
public class TextReader
{
public static void main(
String [] args ) {
Connection c = null;
Statement stmnt = null;
try {
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
c = DriverManager.getConnection( "jdbc:odbc:text_test", "", "" );
stmnt = c.createStatement();
String query = "select * from [test.txt];";
ResultSet rs = stmnt.executeQuery( query );
while( rs.next() )
{
System.out.print( rs.getString( "Field1" ) + "\t");
System.out.print( rs.getString( "Field2" ) + "\t");
System.out.print( rs.getString( "Field3" ) + "\t");
</code>
<em>
System.out.println( rs.getBoolean( "Field4" ) );
</em>
<code>
}
rs.close();
} catch( Exception e ) {
System.err.println( e );
} finally {
try {
stmnt.close();
c.close();
} catch( Exception e ) {
System.err.println( e );
}
} // end of try catch
} // end of main
}
</code>
Output of code:
<pre>
Field1 Field2 Field3 true
this is a false
this2 is2 a2 false
this3 is3 a3 true
</pre>
[This message has been edited by Lee Wallen (edited July 15, 2001).]