internal static void Insert(ProcNote procNote) { if (PrefB.RandomKeys) { procNote.ProcNoteNum = MiscDataB.GetKey("procnote", "ProcNoteNum"); } string command = "INSERT INTO procnote ("; if (PrefB.RandomKeys) { command += "ProcNoteNum,"; } command += "PatNum, ProcNum, EntryDateTime, UserNum, Note, SigIsTopaz, Signature) VALUES("; if (PrefB.RandomKeys) { command += "'" + POut.PInt(procNote.ProcNoteNum) + "', "; } command += "'" + POut.PInt(procNote.PatNum) + "', " + "'" + POut.PInt(procNote.ProcNum) + "', "; if (DataConnection.DBtype == DatabaseType.Oracle) { command += POut.PDateT(MiscDataB.GetNowDateTime()); } else //Assume MySQL { command += "NOW()"; } command += ", " //EntryDateTime + "'" + POut.PInt(procNote.UserNum) + "', " + "'" + POut.PString(procNote.Note) + "', " + "'" + POut.PBool(procNote.SigIsTopaz) + "', " + "'" + POut.Base64(procNote.Signature) + "')"; //MessageBox.Show(cmd.CommandText); DataConnection dcon = new DataConnection(); dcon.NonQ(command); //Debug.WriteLine("Sig length: "+procNote.Signature.Length.ToString()); }