Results 1 to 2 of 2

Thread: MariaDB: DBSuggestionForm not compatible

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Mar 2009
    Location
    New Zealand
    Posts
    1,482

    Exclamation MariaDB: DBSuggestionForm not compatible

    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
    1. Convert Order Entry to MariaDB/MySQL
    2. Change the "oCustomer_Name" form in Customer.vw to a dbSuggestionForm
    3. Set pbFullText of "oCustomer_Name" to TRUE
    4. Compile and Run
    5. Load Customer entry view
    6. Try typing Access in the customer name suggestionform
    7. Nothing appears !?



    Reason

    The SuggestionsSQLFullText procedure builds the SQLFilter as:
    Code:
    "Name" LIKE '%Access%'
    But the correct format for MariaDB/MySQL is:
    Code:
    `Name` LIKE '%Access%'
    Notice the backtick not single quote or double quote.


    To Fix:

    Add "ANSI_QUOTES" to SQL_MODE
    Last edited by raveens; 11-Oct-2019 at 01:36 AM. Reason: Found fix
    Regards,
    Raveen Sundram

    Software Development Manager
    Excellent Software Ltd
    Auckland, New Zealand
    www.xls.co.nz

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •