AS keyword don't work.

[Shahriar Robbani]

SELECT Name AS City_Name FROM City;

When i run this the result of my label don't change! Can anyone help me?

[Takis Diakoumis]

hi

this is a bug on the labelling of the column in the result set. some databases will return the name as the alias used while others stick to the original column name. 

i have a fix for this and will post up a temporary link this weekend.

thanks for reporting :)

Takis

On Fri, Sep 19, 2014 at 2:39 AM, Shahriar Robbani <mineme....@gmail.com> wrote:

SELECT Name AS City_Name FROM City;

When i run this the result of my label don't change! Can anyone help me?

--
You received this message because you are subscribed to the Google Groups "Execute Query" group.
To unsubscribe from this group and stop receiving emails from it, send an email to executequery...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
http://executequery.org

[Shahriar Robbani]

Thank Yoy very much for your reply. Please give me a solution of it. I need it very urgently. EQ is as nice that I cant stop me to using it.... Tnx.....

--
You received this message because you are subscribed to a topic in the Google Groups "Execute Query" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/executequery/hpNU-TkDTXI/unsubscribe.
To unsubscribe from this group and all its topics, send an email to executequery...@googlegroups.com.

[Takis Diakoumis]

hi

try the eq.jar file from here:

http://executequery.org/temp/latest/eq.jar

replace the current one from your installation directory with the one above.

let me know how you go.

thanks :)

Takis

[Shahriar Robbani]

Hey Diakoumis, Its awesome...:D Thank you very much.... It works fine..... EQ is the best and from my viw point sql devoloper is just a shit and wast of 300mb. EQ Rocks!!! :D All the best guys....

[Takis Diakoumis]

glad it worked ok.

let us know of anything else.

thanks :)

Takis

[Shahriar Robbani]

It works perfectly as it should be...:) Well, I want to know something. In EQ the auto suggestions are great but it don't include all MYSQL functions. How to add that in the auto suggestion dictionary?

[Takis Diakoumis]

hi

i'll take a look at this. 

do you mean mysql built-in functions or the functions and procedures that you create in your database?

i'll take a look in any case.

thanks

Takis

[Takis Diakoumis]

hi

i have added system and user defined functions and procedures to the auto-complete list.

you can get an early snapshot here:

http://executequery.org/temp/latest/eq.jar

as before, replace the eq.jar file in your installation directory with the one above.

let me know how you go.

thanks

Takis

--
http://executequery.org

[Shahriar Robbani]

Thank you very much. But i don't know why this jar file is not running in my pc

[Shahriar Robbani]

Sorry, It works fine now. I find all MYSQL function on auto suggestion

Thank you very much.

Shahriar Robbani

[Takis Diakoumis]

glad to hear it :)