Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

(click on this box to dismiss)

Semantic: Cannot coerce host var to type date.

I am very unhappy, this database has many bugs with ADO.NET.

I am trying to insert to datetime to database.

#region FechaNacimiento
CUBRIDParameter tblpacientesfechanacimiento = new CUBRIDParameter();
tblpacientesfechanacimiento.CUBRIDDataType = CUBRIDDataType.CCI_U_TYPE_DATE;
tblpacientesfechanacimiento.Direction = System.Data.ParameterDirection.Input;
tblpacientesfechanacimiento.ParameterName = "?p11";
tblpacientesfechanacimiento.Value = objeto.tblPacientesFechaNacimiento;

tblPacientesFechaNacimiento is type "DateTime"

When can give me a feedback, I have 3 days fighting with this database, is very annoying!! has many problems!!! I am thinking in rollback to postgresql.

link comment (0)
asked 3 years ago
94 Answers
 CREATE TABLE "TblPacientes"(
"tblpacientesfechanacimiento" date NOT NULL,
"tblpacientesfecharegistro" datetime
  public class BoTblPacientes
        public DateTime? tblPacientesFechaNacimiento { get; set; }
        public DateTime? tblPacientesFechaRegistro { get; set; }

the table and the class.
link comment (0)
answered 3 years ago

You are either using a very old browser or a browser that is not supported.
In order to browse you need to have one of the following browsers:

Internet Explorer: Mozilla Firefox: Google Chrome: