>I've the same problems with views sometimes.
>(using RC2)
>After a restore(4k -> 4k) i get numeric overflow errors when i do a select
>on a view.
>(the view not working was made out of two other views which were working
>correctly)
>
>After recreating the view it works again.
>This was reproducable with this backup-file.

Yep, same here - recreating solved it. I checked the system tables to see
if someone the character set and collation got messed up, but I couldn't
find anything.

What we did when creating the db, is modifying the characterset record
in the system tables to have another default collation that the standard
one. First, I thought that this had to do with it - but when I examined
the system tables on the views, I couldn't find anything... So nothing
yet... :(

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

>
> Does it also happen if you restore your backup to a 4K pagesize database?
>
> I've had some (unexplainable) troubles with views - I had to re-create

them

> after a backup before I could get them working... Pretty weird, haven't

yet

> figured out what was wrong and how to reproduce it in a simple case...
>
> Martijn Tonies
> InterBase Workbench - the developer tool for InterBase and Firebird

Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]