Wednesday, March 7, 2012

Error using non-ANSI Joins (Was "Ansi")

Hi everyone.. can anyone help me on how to solve my problem regarding on Select.. im using PB6.5 and running on MSSLQ2005 database.. i attached an image for your reference.. thnks!Moving to SQL Server|||Hi everyone.. can anyone help me on how to solve my problem regarding on Select
Sure: simply follow the recommendation given in the error message: change the compatibility level of your database

You can either do that in the enterprise manager or through a stored procedure.
Check the manual for details|||Ok thnks for the advise ill try to do that.. the original program is running in a MSSQL2000 then i tried to run it in MSSQL2005. i think that the code was not supported in MSSQL2005, is that right??|||=* is no longer supported. I would rewrite the query to use the ansi syntax.|||I would rewrite the query to use the ansi syntax.

thats great thnks!

No comments:

Post a Comment