Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register


0
(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;
#endregion
com.Parameters.Add(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 2 years ago
castle79
60
94 Answers
0
 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 2 years ago
castle79
60
tagged




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



Internet Explorer: Mozilla Firefox: Google Chrome: