Thanks for noting this limit Lester.

I have been using IB for 7 months and had not known this.
I searched the PDF versions of the DevGuide, ApiGuide, LangRef, DataDefGuide
(dated Dec 2000 and Jan 2001) for 256 then 255 and found no reference to a
limit on the number of structural changes one can make.

Is this documented somewhere?

What is the behaviour of IB when the limit, without a backup/restore, is
reached?

Thanks

Russell

----- Original Message -----
From: <lester@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, July 25, 2001 7:31 PM
Subject: Re: [IBO] Re: Object in use when dropping table


> Bare in mind that making structural changes to the database
> do require you to Backup and Restore after ( I think ) 256
> changes. This is a 'problem' that could cause your method to
> become a pain.
>
> I have a 'blank' table into which I pump the data, and then
> just change the SQL to give me the view I want for the
> report and Tee chart. It works well without the structural
> change.
>
> --
> Lester Caine
> -----------------------------
> L.S.Caine Electronic Services
>
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>