private void SetRecNum()
{
DAO.Recordset RS;
string SQL = "Select * from tblSensors order by senRecNum";
RS = mf.Dbase.DB.OpenRecordset(SQL);
if (RS.EOF)
{
cRecNum = 1;
}
else
{
RS.MoveLast();
cRecNum = (byte)(mf.Dbase.FieldToInt(RS, "senRecNum"));
cRecNum += 1;
}
RS.Close();
}
private void SetRecNum()
{
DAO.Recordset RS;
string SQL = "Select * from tblRecords order by recRecNum";
RS = mf.Dbase.DB.OpenRecordset(SQL);
if (RS.EOF)
{
cRecNum = 1;
}
else
{
RS.MoveLast();
cRecNum = (short)(RS.Fields["recRecNum"].Value ?? 0);
cRecNum += 1;
}
RS.Close();
}
public string LastValue(string Table, string Field, string SortField = "", string Where = "")
{
// returns the last value of a field in a table
DAO.Recordset RS;
if (SortField == "")
{
SortField = Field;
}
string SQL = "Select * from " + Table;
if (Where != "")
{
SQL += " " + Where + " ";
}
if (SortField != "")
{
SQL += " order by " + SortField;
}
RS = cDB.OpenRecordset(SQL);
if (RS.EOF)
{
RS.Close();
return("");
}
else
{
RS.MoveLast();
if (RS.Fields[Field].Type == (short)DAO.DataTypeEnum.dbMemo |
RS.Fields[Field].Type == (short)DAO.DataTypeEnum.dbText)
{
RS.Close();
return(RS.Fields[Field].Value ?? "");
}
else
{
RS.Close();
return(RS.Fields[Field].Value ?? 0);
}
}
}
