什么是Access 2010中正确的CASE SELECT语句? [英] What is the correct CASE SELECT Statement in Access 2010?

问题描述

我正在使用vb.net和Access 2010作为数据库(.accdb)

I am using vb.net and Access 2010 as the database (.accdb)

这适用于MySQL:

SELECT user_id, username, first_name, middle_name, last_name,
CASE is_enable WHEN 1 THEN 'Yes' ELSE 'No' END 
FROM tbl_user_accounts ORDER BY user_id

但是当将相同的查询传递给Access时，出现以下错误:

But when passed the same query to Access, I get the following error:

Unrecognized keyword WHEN.

所以我认为CASE语句的访问权限不同，或者访问功能完全具有该功能吗?

So I assume that the CASE Statement is different in access, or does access has that function at all?

P.S.
is_enable是布尔值

P.S.
is_enable is boolean

推荐答案

弄清楚了:
Access 2010没有CASE功能，我们改用SWITCH.

Figured it out:
Access 2010 does not have the CASE function, we use SWITCH instead.

SELECT user_id, username, first_name, middle_name, last_name, SWITCH(is_enable=True,'Yes',is_enable=False,'No') FROM tbl_user_accounts ORDER BY user_id

SELECT user_id, username, first_name, middle_name, last_name, SWITCH(is_enable=True,'Yes',is_enable=False,'No') FROM tbl_user_accounts ORDER BY user_id

感谢chuff和JW.

Thanks to chuff and JW.

这篇关于什么是Access 2010中正确的CASE SELECT语句?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！