If [importing your CSV via the CLI](https://sqlite.org/cli.html#importing_csv_files) works, then the problem is in the Clarion code or its SQLite adapter. Try one and see.
If [importing your CSV via the CLI](https://sqlite.org/cli.html#importing_csv_files) works, then the problem is in the Clarion code or its SQLite adapter. Try one and see.