Re: Query fails to retrieve data

Changing the block size in the BDE only effects FUTURE tables. To change an existing table you have to create a new instance and move the data.

Denn Santoro
President
Resource Development Associates
http://www.RDAWorldWide.Com
Offices in the United States and Germany
Providing solutions to health care, business, governments and non-profits since 1982

spurohit via DBMonster.com wrote:
Steve,
All that I did is change the block size in BDE from 2K to 4K. Also, further
investigation I did today indicates the block size of the table has always
been 16K. Its the block size on BDE that was 2K and I changed it to 4K. So
the current state is something like this:

File size of the table: 130M
Block Size of the table: 16K
Block Size of the Database in BDE: 4K

.