Apostrophes aggggh
Posted: Fri Oct 26, 2012 9:13 pm
I spent all day trying to get NuBuilder to run the form wizard, and every time I put a certain table into the DB it wouldn't work - just gave a half painted screen.
I thought it was because therer were 1000 columns (I inherited this as a Filemaker DB) with some large text fields.
But it turned out to be a field called "Today's date" - so removed the apostrophe and we're away !
Not sure why the previous team wanted to store todays date but there ya go!
It seemed happy with the space until I added the fields to a browse form at which point it errored until I put some backticks round the display and sort names.
So - all happy again
Martin
I thought it was because therer were 1000 columns (I inherited this as a Filemaker DB) with some large text fields.
But it turned out to be a field called "Today's date" - so removed the apostrophe and we're away !
Not sure why the previous team wanted to store todays date but there ya go!
It seemed happy with the space until I added the fields to a browse form at which point it errored until I put some backticks round the display and sort names.
So - all happy again
Martin