topic SQL error in the database when accessing a table in Application Development and Automation Discussions

SQL error in the database when accessing a table

Former Member — Wed, 06 Jan 2010 07:28:20 GMT

Hi,

I have a View, in which we want to add 1 field.

But when we add 1 field in it, I am getting this warning " View read allows read only access, Maintainance not possible".

Second thing: -

That field is showing in view, but when we see it's contents it give a run time error "SQL error in the database when accessing a table."

What should be the problem in it.

regards..

former_member404244 — Wed, 06 Jan 2010 07:41:52 GMT

Hi,

I think it might be due to lack of space in the table ... just a guess. I request to check with basis on this..

Regards,

Nagaraj

Former Member — Wed, 06 Jan 2010 07:58:25 GMT

dear, space problem should not occur only after add 1 field in the table.

Former Member — Wed, 06 Jan 2010 08:03:15 GMT

Hi,

Some points:

1. Make sure the view is a database view. Not other views such as maintenance view.

2. Make sure the VIEW is ACTIVATED.

Only after we activate, the database changes take place.

Regards,

Amit Mittal.

Former Member — Wed, 06 Jan 2010 08:20:21 GMT

If it is a database view and more over when you are creating a database view on one table

check the tab maintaince status it should be read and change...

Please correct that and activate you view.

Now this should work fine

Regards

Satish Boguda