Check_Str = SQLite_RS.Field("PNom")
If InstrB(Check_Str, EndOfLine) <> 0 Then
The code above does not works on Windows while it works fine on macOS (El Capitan and another lower version).
Explanation:
I noticed that sometimes, there are more than one line in fields here only one line is reqited (First Name / Family Name / Husband Name), so I added the code above to flag the error (if one or more EndOfLine character exists in the Field (named PNom above) and two others
I installed the new versions before lunch on both macOS and Windows 7 computers and noticed a difference:
On macOS, I get a small list of errors (fields with more than one line)
On Windows 7: nothing.
Nota: same sqlite file in both computers (I copied it from one OS to the other to be sure).
Also: Records are added from both computers, and manually copied to the other computer when a change is done (a MacBook Pro and a WIndows tower).
Excepted if there is another solution, all I have to Clean one db, move it to the other computer then in the application reject the EndOfLine.<this_platform> (since it is the same as EndOfLine.Linux) for future New Records (or something like that).
Actually, EndOfLine is multiplatform - it contains the default EndOfLine character(s) for the current platform. There’s no magic - it’s basically just a compiled constant.