Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread i can't use alias_name
Fri, Apr 1 2011 6:32 AMPermanent Link

fali

hello.
i can't use alias_name in "SELECT column_name AS alias_name FROM table_name".
alias_name is not English word.it doesn't problem with English words.
for example i can use select foodname as "food" from tblfood.
but i can't use select foodname as "نام غذا" from tblfood.
Mon, Apr 4 2011 2:50 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com


<< i can't use alias_name in "SELECT column_name AS alias_name FROM
table_name". alias_name is not English word.it doesn't problem with English
words. >>

Correct - EDB only accepts certain characters as valid identifiers for
column names, etc.:

http://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=Identifiers

Since column alias names are used to name the result set columns, they must
adhere to the identifier naming rules.

--
Tim Young
Elevate Software
www.elevatesoft.com
Image