Don't use space in Local SQL DB table's column name


#1

Unfortunately, the DreamFactory UI doesn’t automatically detect whether or not your column name has spaces - it will allow you to enter them as is.

I encountered this after creating a new table, adding columns, creating one column called “Phone number”

I went to the Data tab, and tried to load the (empty) table, and an error occurred - it complained about a missing “Phone” column. I immediately realized that it was referring to the “Phone number” column and that I had mistakenly used spaces in it. So, I went back and changed it.


#2

I would use this:

field name = "phone_number"
field label = “Phone Number”


#3

Thank you, that’s what I ended up using.