I have this message when I try to save a register with a primary key formed by two columns (moneda char(1) , fecha datetime ).
The message is SQLSTATE = 42000
sintaxis incorrecta cerca de '00'
no changes made to database
INSERT INTO CA ( MONEDA, FECHA, CAMBIO1, CAMBIO2, CAMBIO3 ) VALUES ( 'D', 2019/11/24 00:00:00:000, 6.9600, 6.9600, 6.9600 )
Can you help me, thanks
SQLSTATE = 42000
Microsoft SQL Server Native Client 11.0
sintaxis incorrecta cerca de '00'
But I change the SQL with ' ' on the datetime column, and works
like that:
INSERT INTO CA ( MONEDA, FECHA, CAMBIO1, CAMBIO2, CAMBIO3 ) VALUES ( 'D', '2019/11/25 00:00:00.000' , 6.9600, 6.9600, 6.9600 );
now How Can I do it from the Datawindow