One database, two tables?

Databases
1

My app is connected to a SQLite database and working fine. I want to create a 2nd table (“Users”) for login purposes. I tried to add that table to my existing database file, but get an error that there is already a table there. Can’t databases have multiple tables? How do I add a 2nd table to my database?

2

Are you adding the table in Xojo code or using an external tool ? Please provide a few screenshots and the exact error message.

3

but get an error that there is already a table there

Is there one already called Users?
Try creating a table called AppUsers instead

4 
CREATE TABLE Users(
ID INT PRIMARY KEY NOT NULL,
Name TEXT NOT NULL,
PasswordHash TEXT NOT NULL,
...
);
5

No, my first table is named “test3”. Not even close.

6

Here’s a screenshot of my code and the error message.

Screen Shot 2022-09-12 at 6.34.47 AM
Screen Shot 2022-09-12 at 6.34.47 AM1842×1252 281 KB

7

Your string concatenation is definitely wrong. You do:

sql2 = sql + …

should be:

sql2 = sql2 + …

Alwaysbusy

8

You’re absolutely right!!

9

If you want to write a string over multiple lines then simply use +_

sql2 = "CREATE TABLE Users (" +_
  "id integer, " +_
  "firstname varchar, " +_
  "username varchar, " +_
  "password varchar, " +_
  "PRIMARY KEY(id))"
1 Like