But I have no views, in my case there are only tables involved.

Guido

Martijn Tonies wrote:

> >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]
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/