gguidarelli
Programmer
Sorry in advance if this was answered elsewhere, but I couldn't find anything like this...
I have a DBC with some tables in it. Some of these tables have memo fields. I just ran into a problem with the FPT file sizes becoming HUGE. Turns out the blocksize was set to 64 (the default), and after some testing, realized that a blocksize of 1 (SET BLOCKSIZE TO 0) would be best (since the data being stored in the memo fields is usually 1 char, but occasionally a lot more).
Anyway, I need to re-create this table using the new BLOCKSIZE. How do I do this while keeping its database link and all the other database-type stuff (like relations, etc.) intact?? Oh, and I want to keep all this stuff intact without having to know what it all is. Am I asking too much??
use mytable
set blocksize to 0
copy to newtable with cdx database abc
rename table mytable to oldtable
rename table newtable to mytable
* BUT! all this does is add a new table to the database, but the one I want to replace is still there with the relations pointing to it...
I have a DBC with some tables in it. Some of these tables have memo fields. I just ran into a problem with the FPT file sizes becoming HUGE. Turns out the blocksize was set to 64 (the default), and after some testing, realized that a blocksize of 1 (SET BLOCKSIZE TO 0) would be best (since the data being stored in the memo fields is usually 1 char, but occasionally a lot more).
Anyway, I need to re-create this table using the new BLOCKSIZE. How do I do this while keeping its database link and all the other database-type stuff (like relations, etc.) intact?? Oh, and I want to keep all this stuff intact without having to know what it all is. Am I asking too much??
use mytable
set blocksize to 0
copy to newtable with cdx database abc
rename table mytable to oldtable
rename table newtable to mytable
* BUT! all this does is add a new table to the database, but the one I want to replace is still there with the relations pointing to it...