Hello…
I have a form with a date and a time field.
In my developmen enviroment, work fine.
But in production enviroment, when execute the insert generated by scriptcase, replace the ’ at begin and end of date an time fields, by -
And the SQL give an error…
Bad
INSERT INTO dbo.news_noticias (NOTICIA_ID, NOTICIA_DATA_NOTICIA, NOTICIA_HORA_NOTICIA, NOTICIA_TITULO, NOTICIA_CORPO, NOTICIA_PUBLICADA, COD_RUBCOMERCIAL, COD_LISTA, PUBLICACIONGENERAL) VALUES (1, -2020-07-03 00:00:00:000-, -1900-01-01 17:46:55:000-, ‘’, ‘’, 0, 0, 0, 1)
Good
INSERT INTO dbo.news_noticias (NOTICIA_ID, NOTICIA_DATA_NOTICIA, NOTICIA_HORA_NOTICIA, NOTICIA_TITULO, NOTICIA_CORPO, NOTICIA_PUBLICADA, COD_RUBCOMERCIAL, COD_LISTA, PUBLICACIONGENERAL) VALUES (1, ‘2020-07-03 00:00:00:000’, ‘1900-01-01 17:46:55:000’, ‘’, ‘’, 0, 0, 0, 1)
I use SQL Server…
What i can set enviroment production, to correct insert the register?
Thanks!!!