SQL error in the database when accessing a table

[Former Member]

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]

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]

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

[Former Member]

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]

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