'"Warning: SQL contains join, recordset not updatable" when I use this SQL query with CDatabase in MFC

I have this function to query some records from my MDB / ACCDB database:

CString         strQuery, strNumber;

if (m_dbDatabase.IsOpen())
{
    if (m_pRecords != nullptr)
    {
        strQuery.Format(_T("SELECT [Home Talks].*, [Public Talk Titles].[Theme] FROM [Home Talks] ")
                        _T("LEFT JOIN [Public Talk Titles] ON ")
                        _T("[Home Talks].[Talk Number] = [Public Talk Titles].[Talk Number] ")
                        _T("WHERE [Home Talks].[id] = %d"), iRecordID);

        if (m_pRecords->Open( CRecordset::dynaset, (LPCTSTR)strQuery ))
        {
           // Do stuff
        }
        m_pRecords->Close();
    }
}

It works fine and 100% of the time always reads data correct. But, I have noticed in DEBUG x64 mode the following warning in the Output log:

D:\a_work\1\s\src\vctools\VC7Libs\Ship\ATLMFC\Src\MFC\dbcore.cpp(2890) : AppMsg - Warning: SQL contains join, recordset not updatable

I thought I would just try to use CRecordset::readonly and then then Open method crashed. Is there any way to avoid this warning? Or is it just for information and to be ignored?

visual-c++mfcleft-joincrecordsetjavaspring-boot


Solution 1:[1]

Personally I prefer to use the @Slf4j annotation for logging with Spring boot but here is a nice list of the possibilities:

https://www.baeldung.com/spring-boot-logging

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 The_Unknown

Related Questions