Spaces and Apostrophes Prevent Updates/Deletes
I have a table named "positions." The sole column within the table is named "position." It's also the primary key. I used the DataAssist Wizard to generate Results, Insert, Update and Delete pages. Everything is fine until I insert values with spaces or apostrophes, like
Vice President
President's Assistant
The data inserts fine, but it refuses to update or delete. I don't get any error messages -- after clicking the button on either the update or delete pages I end up back at the results page with unchanged/undeleted data.
Other punctuation marks may/may not cause this problem. Once I found the 'root' I started looking for a solution.
Any help is appreciated!! I bought the Dynamic Suite so I wouldn't have to hand-code as much, and I'm a little perplexed that it (seemingly) can't handle routine operations on a one-column table. (It could always be user error, of course!)
Thanks,
Sharon