RS = db.MySQLSelect("SELECT InventoryID,InventoryIn,InventoryOut,TimeRecorded, unit, productname from Inventory,Product where TimeRecorded=Date(now()) AND prCode=ProductCode;");
try {
while (RS.next()) {
Records.add(new InventoryRecord(RS.getString(1), RS
.getString(5), RS.getString(6), RS.getDate(4), RS
.getInt(2), RS.getInt(3)));
ctr++;
}
RS.close();