Tuesday, March 27, 2012

Error: Command not properly ended

Hi there,
Would appreciate if someone can have a glance at this code, and tell me
what SQL Talk doesnt like about it?
SELECT X, Y, Z, A, B FROM TSECURITY_LEVEL INTO :x, :y, :z, :a, :b
WHERE 1=1 ORDER BY A;
^
Error: Command not properly ended
Thanks All,
Sam
Sam
SELECT <columns list> INTO #Test FROM MyTable WHERE blabalabala
"Sam" <sammA11111@.hotmail.com> wrote in message
news:1132738877.588734.57500@.g49g2000cwa.googlegro ups.com...
> Hi there,
> Would appreciate if someone can have a glance at this code, and tell me
> what SQL Talk doesnt like about it?
> SELECT X, Y, Z, A, B FROM TSECURITY_LEVEL INTO :x, :y, :z, :a, :b
> WHERE 1=1 ORDER BY A;
> ^
> Error: Command not properly ended
> Thanks All,
> Sam
>
|||Thanks for the reply Uri.
rookie mistake, and the problem is sorted ;)
sam

No comments:

Post a Comment