We have a form with multiple lookup rules that accept user input from text fields. They behave as expected until the input value contains double quotes. More confusing to us is that the field lookup will return a value if there is only one set of double quotes.
User input of ' The "Th ' will return both ' The "Thing" About That' and ' The "Theory" of Constraints ', but if a user submits ' The "Thing" ', the filed lookup returns no values.
We're using stored procedures as the data source. The stored procedures execute as expected for all of these example values when executed in SQL Server Management Studio. It looks like Forms is doing something unanticipated when it hits the second double quote in the string.
Has anyone else encountered this? Do you have a solution?