"SELECT MONTHNAME(samedate) AS aMonthName FROM somedb’
works as expected in the SQL builder and other systems I use, it returns the month name - Januray, February etc…
In SC8 grid and forms only numbers (ie 1, 2 etc) are shown.
Any ideas, or is it another SC feature I should just learn to adapt to?
PS: I switched to manual lookup.