Re: SQL Convert problem

2018-10-30 Thread vagelis fallias via 4D_Tech
It worked , Thank you Στις Δευτέρα, 29 Οκτωβρίου 2018, 1:51:45 μ.μ. GMT-4, ο χρήστης Charles Miller έγραψε: Try cast. Chuck  On Mon, Oct 29, 2018 at 12:37 PM vagelis fallias via 4D_Tech <4d_tech@lists.4d.com> wrote: Hello, I have the following statement from an external application to

Re: SQL Convert problem

2018-10-29 Thread Charles Miller via 4D_Tech
Try cast. Chuck On Mon, Oct 29, 2018 at 12:37 PM vagelis fallias via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hello, > I have the following statement from an external application to 4D via ODBC >var_SelectQuery = "select workorder, > convert(prodstartdate,SQL_VARCHAR), prodstarttime, plansta

SQL Convert problem

2018-10-29 Thread vagelis fallias via 4D_Tech
Hello, I have the following statement from an external application to 4D via ODBC    var_SelectQuery = "select workorder, convert(prodstartdate,SQL_VARCHAR), prodstarttime, planstarttime from workorders  where workorder > 278000" this used to work in v 6.8 but not in v16, it crashes. The problem i