Replacing a VIEW with another one 1

[markajem]

C v8.5

I had to change a VIEW that I am presently using in my report.

Existing VIEW
field01
field02

New VIEW
field01 <-- same as existing
field02 <-- same as existing
field03 <-- added field

I did this once before a while back and for the life of me can't remember. All my fields that I am using in my report are pointing to the existing VIEW, even if I do Set Location I still only see the original fields from my existing VIEW. How do I get it to start using the new VIEW that has the added field without having to recreate the entire report using the new VIEW.

Thanks

 

[synapsevampire]

Use the Database->Set Location and point to the other View.

A screen will pop up to map any fields if it can't do so itself.

Then you'll see the new fields as well.

-k

 

[markajem]

I thought of that but that I believe would be that if I removed a field from the original VIEW and still had it in the report then it would ask me where to map it.

I solved it though. Was not thinking straight (as usual). I had to do "Verify Database" and it added the new field to my existing VIEW.

Thanks for the suggestion anyway.

 

[markajem]

Also I should have mentioned and made more clearly. It was not a new VIEW but the same VIEW altered with the same name.

 

[synapsevampire]

Right, that's because you said that you had a new view, not that you'd left it unclear or that you'd modifed the existing View.

And yes, my solution worked as stated when using a NEW view.

-k