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); } } }