Building examples of special characters as column names in business table building

Metric rapid development platform, when the business table is built, the name of the set column may start with a number, and normally the database must not be listed as a number, such as:
Select A.suoshudanweiid,sum (case when B.jianchaxiangmu = ' gps not online ' then 1 else 0 end) GPS is not online,
SUM (case when b.jianchaxiangmu = ' 3G video unqualified ' then 1 else 0 end)3G Video not qualified
From Project_check A,project_check_detail b
where a.id = B.libaolijianid and B.shifouhege = 0 GROUP BY suoshudanweiid




In general, in Query Analyzer, we add brackets or double quotes to the list of numbers.
Method One:
Select A.suoshudanweiid,sum (case when B.jianchaxiangmu = ' gps not online ' then 1 else 0 end) GPS is not online,
SUM (case when b.jianchaxiangmu = ' 3G video unqualified ' then 1 else 0 end)[3G Video not qualified]
From Project_check A,project_check_detail b
where a.id = B.libaolijianid and B.shifouhege = 0 GROUP BY suoshudanweiid

Method Two:
Select A.suoshudanweiid,sum (case when B.jianchaxiangmu = ' gps not online ' then 1 else 0 end) GPS is not online,
SUM (case when b.jianchaxiangmu = ' 3G video unqualified ' then 1 else 0 end) as "3G video unqualified"
from Project_ CHECK a,project_check_detail b 
where a.id = B.libaolijianid and B. Shifouhege = 0  group by suoshudanweiid


in the Metric rapid development platform, we set variables in the business table with [: variable name], so in the way of a square bracket, An error occurs when the business table is saved.
 
If you really want a special number to be listed, you can name it in the business table as not a number, and then re-name the column on the form interface. For example, a grid part can set the field display Name: Grid Part 1. Setcolumncaption ("Video not Qualified", "3G video not qualified"). The

is also implemented by means of method two. With     as   column name

Original address: http://plat.delit.cn/thread-619-1-1.html

Reprint please specify the source:

Author: metric Technology www. Delit. cn

Building examples of special characters as column names in business table building