expectation
really
Do any plugin dll is necessary?
expectation
really
Do any plugin dll is necessary?
ok, it MSSQL. That's a case for Anse (the Author) then, to activate the appropriate input editors for types SMALLDATETIME and whatever type mappings
is (should probably be treated like mysql ENUM).
Please do post another screenshot with CREATE CODE for the field mappings
; that will increase the probability that the will be able to do something about your problem.
Please also post the result of SELECT @@version , since the capabilities of different versions of MSSQL server differ considerably.
ok, it MSSQL. That's a case for Anse (the Author) then, to activate the appropriate input editors for types SMALLDATETIME and whatever type
mappings
is (should probably be treated like mysql ENUM). Please do post another screenshot with CREATE CODE for the fieldmappings
; that will increase the probability that the will be able to do something about your problem. Please also post the result of SELECT @@version , since the capabilities of different versions of MSSQL server differ considerably.CREATE TABLE "SIAF_HORARIOS_EMPLEADOS_DIAS" ( "Conse" INT NOT NULL, "Fecha" DATE NULL DEFAULT NULL, "Codigo_Horario" NVARCHAR(20) NULL DEFAULT NULL, "Dia" NVARCHAR(5) NULL DEFAULT NULL, "Convencion" NVARCHAR(2) NULL DEFAULT NULL, "Cedula" NVARCHAR(11) NULL DEFAULT NULL, "Entrada_Turno" SMALLDATETIME NULL DEFAULT NULL, "Entrada_Descanso" SMALLDATETIME NULL DEFAULT NULL, "Salida_Descanso" SMALLDATETIME NULL DEFAULT NULL, "Salida_Turno" SMALLDATETIME NULL DEFAULT NULL, "Total_Horas_Turno_Dia" NUMERIC(18,7) NULL DEFAULT NULL, "Total_Horas_Trabajadas" NUMERIC(18,7) NULL DEFAULT NULL, "Horas_Extras" NUMERIC(18,7) NULL DEFAULT '0', "Horas_Perdidas" NUMERIC(18,7) NULL DEFAULT '0', "Horas_Compensadas" NUMERIC(18,7) NULL DEFAULT '0', "Codigo_Punto" NVARCHAR(20) NULL DEFAULT NULL, "Codigo_Permiso" NVARCHAR(20) NULL DEFAULT NULL, PRIMARY KEY ("Conse") ) ;
result of SELECT @@version
Microsoft SQL Server 2012 - 11.0.2100.60 (X64) Feb 10 2012 19:39:15 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2)
thank you. However, I meant the CREATE CODE hat shows the field "mappings" (in your first screenshot). Or was this just an example and your main problem is with SMALLDATETIME fields ? ..also I notice that SMALLDATETIME is not highlighted in the above screenshot (grey, not green), so possibly it is not yet recognized as a valid datatype by heidisql at all.
thank you. However, I meant the CREATE CODE hat shows the field "mappings" (in your first screenshot). Or was this just an example and your main problem is with SMALLDATETIME fields ? ..also I notice that SMALLDATETIME is not highlighted in the above screenshot (grey, not green), so possibly it is not yet recognized as a valid datatype by heidisql at all.
thanks
problem is not only SMALLDATETIME fields :
(DATETIME datatype)
:
===================================================================================
===================================================================================
I'm sorry, I could not find the option mentioned CREATE CODE hat
Please login to leave a reply, or register at first.