SQL Noob Questions

[Tiramisu]

I am trying to use a simple for-loop and the internet suggests something like

DECLARE @cnt INT = 0;

WHILE @cnt < cnt_total
BEGIN
   -- {...statements...}
   SET @cnt = @cnt + 1;
END;

but this does not work for me. Even when I am just using
DECLARE @cnt INT = 0;
to declare a simple variable, then the whole code will not work.
So is the SQL in Civ6 different than the "normal" version of SQL or am I making any mistakes?

 

[Wolfdog]

I am trying to use a simple for-loop and the internet suggests something like

DECLARE @cnt INT = 0;

WHILE @cnt < cnt_total
BEGIN
   -- {...statements...}
   SET @cnt = @cnt + 1;
END;

but this does not work for me. Even when I am just using
DECLARE @cnt INT = 0;
to declare a simple variable, then the whole code will not work.
So is the SQL in Civ6 different than the "normal" version of SQL or am I making any mistakes?

Can't help you with your code as I am no coder but I can tell you that Civ6 uses SQLite.

 

[Tiramisu]

Civ6 uses SQLite.

You are right! I totally forgot this.
Now instead of a loop I have manually created a table that contains all the loop variables, so I can use this table in a SELECT ... FROM ... statement. At least this works.