column alias at oraquey component

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
sidlc
Posts: 2
Joined: Mon 18 Dec 2006 16:47

column alias at oraquey component

Post by sidlc » Sat 10 Mar 2007 08:43

Hello all
I'm trying Odac 6 Beta for Delphi 7 and I can not execute sql statments using
toraquery when I'm using column alias with greek characters.
Example:
SELECT kodikos||'/ '||title "Εργο", ERGO_ID ID,Comp_comp_id "Company" ,APPROVED_BUDGET "Budget"
,APPROVED_START_DATE "Start" ,APPROVED_FINISH_DATE "End"
FROM ERGA A
When I'm trying to execute above sql the result error is : "Identifier is to long"
but when I change the column alias to English as following :
SELECT kodikos||'/ '||title "Project", ERGO_ID ID,Comp_comp_id "Company" ,APPROVED_BUDGET "Budget"
,APPROVED_START_DATE "Start" ,APPROVED_FINISH_DATE "End"
FROM ERGA A
the query is running correctly
What shall I do I do in order to have column alias with greek characters in the Toraquery?

( I inform you that using Oracle's Sql Developer tool to execute such querys
there are not errors at all)
Thank you

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Mon 12 Mar 2007 10:27

We could not reproduce the problem. Please send to odac*crlab*com a complete small sample that demonstrates the problem, including script to create server objects.

sidlc
Posts: 2
Joined: Mon 18 Dec 2006 16:47

sample prgr sent

Post by sidlc » Sat 17 Mar 2007 08:57

Well I sent to you in the [email protected] mail a small program to demonstrate the problem similar with which I mentioned before. If you try to open the query in the form (in the project) you will see that Oracle returns the error "SQL command not properly ended" but if you replace the greek characters in the Where class with latin characters , the query will be executed with no errors. The same occures with column alias with greek characters.


I'm waiting for your answer asap.

Post Reply