PDA

View Full Version : Problem with brackets in SQL field names


ABC123

aririch
05-27-2011, 09:12 AM
Hello all
I am using Alpha 5 v10 against MS Sql database.
In this database are field names in brackets for example [Qty in unit]
which is widely used in Microsoft dynamics Nav (The business software
Microsoft bought several years ago).
The problem I have is that the dynamics filters in the grids don't work at all,
and when I view the xbasic code the brackets has been removed by Alpha.
The question is, is this a bug or are brackets not allowed in fieldnames and
if so is there any way around it.

Regards, Ari H Richardson