final ISqlJetCursor lookup = table.lookup(NAME_INDEX, TEST);
Assert.assertTrue(!lookup.eof());
final boolean firstNull = lookup.isNull(NAME_FIELD);
Assert.assertFalse(firstNull);
final SqlJetValueType firstType = lookup.getFieldType(NAME_FIELD);
Assert.assertTrue(firstType == SqlJetValueType.TEXT);
final String firstName = lookup.getString(NAME_FIELD);
Assert.assertNotNull(firstName);
Assert.assertEquals(TEST, firstName);
final boolean gotoSecond = lookup.next();
Assert.assertTrue(gotoSecond);
final boolean secondNull = lookup.isNull(NAME_FIELD);
Assert.assertFalse(secondNull);
final SqlJetValueType secondType = lookup.getFieldType(NAME_FIELD);
Assert.assertTrue(secondType == SqlJetValueType.TEXT);
final String secondName = lookup.getString(NAME_FIELD);
Assert.assertNotNull(secondName);
Assert.assertEquals(TEST, secondName);