RE: [sqr-users] (SQR 3716) Error in SQL statement.Error in includefile

["the dragon" <ceprn@hotmail.com>]

Oracle allows || as concats...

peace,
clark 'the dragon' willis



PSA: Salary <> Slavery. If you earn a salary, your employer is renting your 
services for 40 hours a week, not purchasing your soul. Your time is the 
only real finite asset that you have, and once used it can never be 
recovered, so don't waste it by giving it away.

I work to live; I don't live to work.

"Time is the coin of your life. It is the only coin you have, and only you 
can determine how it will be spent. Be careful lest you let other people 
spend it for you."

Carl Sandburg
(1878 - 1967)

It is impossible to defeat an ignorant man in argument.

William G. McAdoo

----Original Message Follows----


The code after the union (or any set operator) has to be straight SQL
(no SQR).  So your SQR concatenate thingys (||) throw the parser into a
tailspin.

Richard Knapp
AITS - Reporting

-----Original Message-----

This line doesn't look right:
where calendar_year = 2004)) || '    '

Run the code with the -s option to see the actual sql sent to the
database.
Steve.

-----Original Message-----

When I run the below code ....
I get these 2 errors
    Error in include file sqr\curdttim.sqc
   (SQR 3716) Error in SQL statement.

_________________________________________________________________
Try the next generation of search with Windows Live Search today!  
http://imagine-windowslive.com/minisites/searchlaunch/?locale=en-us&source=hmtagline


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users