PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

Inicio → WINDEV 2024 → [WD7.5] Column names with spaces
[WD7.5] Column names with spaces
Iniciado por alex_using_windev, 06,jun. 2003 14:31 - No hay respuesta
Publicado el 06,junio 2003 - 14:31
Hi all

I'm still seeing a problem with column names with spaces from Microsoft SQL
sources. Seems to be a problem in calculations. For example, with Northwind
I can't seem to get[Order Details].UnitPrice * [Order Details].Quantity in
the final SQL for the query editor. If I type the [] manually in the formula
editor they are stripped out. Simply choosing of a column name to display
is okay. You get [Order Details].UnitPrice in the generated SQL, for example.

Alex