Java Doc for TableDataSet.java in  » Database-ORM » Torque » com » workingdogs » village » Java Source Code / Java DocumentationJava Source Code and Java Documentation

Here is an example usage for this code that gets the first 10 records where column "a" = 1:

 KeyDef kd = new KeyDef().setAttrib("column");
 TableDataSet tds = new TableDataSet(connection, "table_name", kd );
 tds.where ("a=1" ); // WHERE a = 1
 tds.fetchRecords(10); // fetch first 10 records where column a=1
 for ( int i=0;i< tds.size(); i++ )
 {
 Record rec = tds.getRecord(i); // zero based
 String columnA = rec.getValue("a");
 if ( columnA.equals ("1") )
 System.out.print ("We got a column!");
 }
 tds.close();
 

It is important to remember to always close() the TableDataSet when you are finished with it.

As you can see, using a TableDataSet makes doing selects from the database trivial. You do not need to write any SQL and it makes it easy to cache a TableDataSet for future use within your application.

Default value is false.

Default value is false.

FIXME: Is this right? I don't use Sybase.