PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

Accueil → WINDEV 2024 → [WD7.5] Column names with spaces
[WD7.5] Column names with spaces
Débuté par Alex McCullie, 06 juin 2003 14:31 - Aucune réponse
Posté le 06 juin 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