Invalid column name.

[bosavvy]

I get this invalid column name error when , I refresh a document with prompts.Can anybody help me?

 

[skrandel]

Are the prompts built into conditions or are they prompts built in the query panel?

Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com

 

[bosavvy]

They are prompts built in the conditions

 

[skrandel]

This means that you have errors in your condition objects. Something has changed since your report was built. You now have a condition object that points to something that no longer exists in your database.

Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com

 

[bosavvy]

Well,I am getting this error when, I am using the year object. I observed the universe too and the object exists and is pointing to the right tables.

 

[xlbo]

I've had this error occur when I had development universes on my computer as well as live ones. If there are any duplicate names in the LOV files, it was popping up with that message ie we had a dev set of LOVs and a live set - when they were called the same name, it gave this error - random I know but there's not many BO error messages that actually make sense ;-)

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244