SQLite multi word table name

I need to be able to read in a CSV file, two of the table names that are included are:

“Sworn PR” and “Sworn Full”.

Xojo 3.2 i snot allowing me to create a SQLite database table with these names. ANy work arounds?

Do you mean you can’t do a:

SELECT * FROM "Sworn Full"

?

1 Like

My personal preference is to not allow spaces in sql names. Use ReplaceAll to change spaces to underscores.

3 Likes