-
1
- #1
We've recently run into a scenario where a user had accidentally hit the backtick character while doing data entry in an editbox (VFP9). In this case they actually typed the sequence [kbd]` [/kbd] (backtick - space), which result in a NUL char '\0' being inserted.
This edit box is bound to a remote view memo field, and caused a SQL failure during the [tt]TABLEUPDATE()[/tt]
Ideally there would be some sort of global FoxPro [tt]SET[/tt]ting which would disable this, but I have had no luck finding it if it exists.
Besides going through and handling these characters during data entry in [tt]KeyPress[/tt] and issuing a [tt]NODEFAULT[/tt] is there any other more elegant way if preventing this that I haven't thought of yet?
This edit box is bound to a remote view memo field, and caused a SQL failure during the [tt]TABLEUPDATE()[/tt]
Ideally there would be some sort of global FoxPro [tt]SET[/tt]ting which would disable this, but I have had no luck finding it if it exists.
Besides going through and handling these characters during data entry in [tt]KeyPress[/tt] and issuing a [tt]NODEFAULT[/tt] is there any other more elegant way if preventing this that I haven't thought of yet?