Hi Daw,
It seems that the way the DBSuggestionForm, or more precisely the DD, builds the SQLFilter is not compatible with MariaDB/MySQL
To Test
- Convert Order Entry to MariaDB/MySQL
- Change the "oCustomer_Name" form in Customer.vw to a dbSuggestionForm
- Set pbFullText of "oCustomer_Name" to TRUE
- Compile and Run
- Load Customer entry view
- Try typing Access in the customer name suggestionform
- Nothing appears !?
Reason
The SuggestionsSQLFullText procedure builds the SQLFilter as:
But the correct format for MariaDB/MySQL is:Code:"Name" LIKE '%Access%'
Notice the backtick not single quote or double quote.Code:`Name` LIKE '%Access%'
To Fix:
Add "ANSI_QUOTES" to SQL_MODE