SQLiteException: near "If": syntax error

Question

I am converting a 'SQL Server 2008' stored procedure to 'SQLite'. But facing problem with the following query:

If (Select Count(UserId) From Users Where RememberMe = 'True') > 1
Update Users Set RememberMe = 'False'
Select UserName From Users Where RememberMe = 'True'

While executing the above query in the 'SQLite Administrator' or 'SQLite Expert', I am getting the following error message:

Error occured: near "If": syntax error

I am a beginner in SQLite. Please guide me.

Thanks & Regards,

Giorgi · Accepted Answer · 2011-04-16 18:34:49Z

2

Sqlite does not support if. You can use CASE instead of it.

answered Apr 16, 2011 at 18:34

Giorgi

31k13 gold badges92 silver badges128 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Paul Lefebvre · Accepted Answer · 2011-04-20 04:01:24Z

0

SQLite doesn't support stored procedures.

But it looks like your code only updates the Users table to set RememberMe = 'False' for users that had it set to 'True'. If this is the case, then you don't need to do the If part at all. This should suffice:

UPDATE Users SET RememberMe = 'False' WHERE RememberMe = 'True';

answered Apr 20, 2011 at 4:01

Paul Lefebvre

6,4364 gold badges31 silver badges37 bronze badges

Collectives™ on Stack Overflow

SQLiteException: near "If": syntax error

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related