Hello, i have this piece of code that works perfect if i run it.
however, when i publish it, i get a 'Not a valid month' dB error.
Dim Now As Date = Date.Now
Dim d As String = Format(Now, "dd/MM/yyyy")
dms = New OracleDataClass.OracleDataClass(dbdms, userdms, passworddms)
query = "update cts_shipments set shipping_date = '" + d + "' where status in ('RG','MF')"
'query = "update cts_shipments set shipping_date = TO_CHAR(CURRENT_DATE, 'DD/MM/YYYY') where status in ('RG','MF')"
query = query.Replace(ControlChars.NewLine, " ").Replace(ControlChars.CrLf, " ").Replace(ControlChars.Tab, " ").Replace(" ", " ").Replace(" ", " ").Replace(" ", " ").Replace(";", "")
resultaat = dms.ExecuteNonQuery(query)
the first time i raan this code, it was trying to put into the database 10/06/2010, so even if it was trying american format in european format or vica verca, it would not have had a problem with this since 06/10 or 10/06 are avaible in both formats.
does anyone ever have a similar problem with a published program?