SQLITECPP_USE_STATIC_RUNTIME doesn't work on CMake 3.25

[ghuser404]

Setting SQLITECPP_USE_STATIC_RUNTIME to ON, the generated MSVC project files still use /MD flag.

To solve this, CMAKE_MSVC_RUNTIME_LIBRARY should be set.

Here is how glfw solves this:

if (MSVC AND NOT USE_MSVC_RUNTIME_LIBRARY_DLL)
    if (CMAKE_VERSION VERSION_LESS 3.15)
        foreach (flag CMAKE_C_FLAGS
                      CMAKE_C_FLAGS_DEBUG
                      CMAKE_C_FLAGS_RELEASE
                      CMAKE_C_FLAGS_MINSIZEREL
                      CMAKE_C_FLAGS_RELWITHDEBINFO)

            if (flag MATCHES "/MD")
                string(REGEX REPLACE "/MD" "/MT" ${flag} "${${flag}}")
            endif()
            if (flag MATCHES "/MDd")
                string(REGEX REPLACE "/MDd" "/MTd" ${flag} "${${flag}}")
            endif()

        endforeach()
    else()
        set(CMAKE_MSVC_RUNTIME_LIBRARY "MultiThreaded$<$<CONFIG:Debug>:Debug>")
    endif()
endif()

[SRombauts]

Hey @ghuser404, thanks for reporting, looks promising!
If you can propose a change, I'd be happy to review it.

[UnixY2K]

this should be ready to close as #438 was merged

[SRombauts]

Yes, thanks for the reminder!