|
|
| Levy Delgado 2005-10-27, 8:21 am |
| I'm using ASE 12.5 ...
How can I make this query work?
select "employee"."emp_no" from employee --- this query
would result to an incorrect syntax...
most of my queries are in this form.
ASE Baby,
Levy
| |
| Shivakumar K 2005-10-27, 8:21 am |
| Hi,
Just take off those quotation ("") marks..!
That shoud solve it..
Cheers
Shivakumar K
> I'm using ASE 12.5 ...
>
> How can I make this query work?
>
> select "employee"."emp_no" from employee --- this query
> would result to an incorrect syntax...
>
> most of my queries are in this form.
>
> ASE Baby,
>
> Levy
| |
| Fabian Oliveira 2005-10-27, 8:21 am |
| .... or check database you´re using ...
If this don´t solve your problem, post the database´s error message.
Fabian
<Shivakumar K> escreveu na mensagem
news:43564050.6d52.1681692777@sybase.com...[color=darkred]
> Hi,
> Just take off those quotation ("") marks..!
> That shoud solve it..
>
> Cheers
> Shivakumar K
>
| |
| Stefan Karlsson 2005-10-27, 8:21 am |
| <Levy Delgado> wrote in message news:43561e34.6b15.1681692777@sybase.com...
> I'm using ASE 12.5 ...
>
> How can I make this query work?
>
> select "employee"."emp_no" from employee --- this query
> would result to an incorrect syntax...
>
> most of my queries are in this form.
SET QUOTED_IDENTIFIER ON
HTH,
/Stefan
| |
| Levy Delgado 2005-10-27, 8:21 am |
| Hello,
Thanks.
But is there any other way ASE will allow quotation marks
without me removing them?
Why is ASE so strict with this? I heard it's okay in ASA.
Thanks,
Chris
> ... or check database you=b4re using ...
>
> If this don=b4t solve your problem, post the database=b4s
> error message.
>
> Fabian
>
> <Shivakumar K> escreveu na mensagem
> news:43564050.6d52.1681692777@sybase.com...
>
>
| |
| Dmitri 2005-10-27, 8:21 am |
| Levy Delgado wrote:
> But is there any other way ASE will allow quotation marks
> without me removing them?
AFAIK, no, but I think one working method is enough.
> Why is ASE so strict with this?
For historical reasons.
> I heard it's okay in ASA.
Correct, but ASA isn't ASE.
Dmitri.
| |
| Levy Delgado 2005-10-27, 8:21 am |
| Historical Reasons?... If you don't mind me asking, Can you
give some of this "Historical Reasons"?(I'm just curios :) )
...
Thanks Anyways...
Hey! what does the standards say about the "SELECT
STATEMENT" syntax? Maybe the syntax in ASA is not standard
am I right?
Thanks Again,
Levy
> Levy Delgado wrote:
>
>
> AFAIK, no, but I think one working method is enough.
>
>
> For historical reasons.
>
>
> Correct, but ASA isn't ASE.
>
> Dmitri.
| |
| Dmitri 2005-10-27, 8:21 am |
| Levy Delgado wrote:
> Historical Reasons?... If you don't mind me asking, Can you
> give some of this "Historical Reasons"?(I'm just curios :) )
"Historical Reasons" are "It Used To Be That Way" (like (+) for outer
join in Oracle). However, I'm not a big ASE expert for my words to be
taken for granted ;).
> Maybe the syntax in ASA is not standard
Maybe. But ASE it old enough to be a standard itself :).
Dmitri.
|
|
|
|