Hi All, I've been having some fun trying to change the BDE 'block size' during run time. I need to generate large answer tables and I don't want to drag every user though the BDE Administrator. I have no access to their machines other than my software. I like the idea of only modifying the settings when my program is running instead of changing their idapi.cfg file.  "rptSession" is a TSession component in the below example. TStringList* tsl = new TStringList(); rptSession->GetConfigParams("\CONFIGURATION\DRIVERS\NATIVE\PARADOX\%s","BLOCK SIZE",tsl);, I can compile, and no matter what permutation of path I dictate, the engine can't find the parameter that I specify. I want to read the current block size, then modify it while the session is active. Thanks in Advance! Jim Shedden

Posted to MB Topic: C++Builder « C++ Board

Hi All, I hit a strange one, the saga of the three table add. All files are Paradox 7 with primary keys, 16 block size, 555 byte record size, and each verify as OK. They are: US (338829 records) EU (179069 records) JP (81668 records) The addition often results in a corrupt table based on the sequence of additon. US+EU+JP = No Good repeatable on multiple machines and OS's, Paradox 10 and 11 and C++ builder custom code. It is apparently the BDE. US+EU = Good US+JP = Good US+(EU+JP) = Good and this was my solution Paradox is running single user, local database at the time. Has anyone seen this? I'm concerned as I will be concatinating databases from other countries very soon and I'm a little nervous. The BDE settings have Local Share True and all the common tweaks for memory etc. Thanks in Advance! Regards, Jim Shedden

Posted to MB Topic: Paradox Tables « Paradox Board

Hi Bryan, Thanks for the reply. I've used Paradox Table Add from the menu in Paradox 10 and 11. I've also used two TTables and a TBatchMove component in C++ (which I've done successfully literally hundreds of times.). Here is what that code looks like:  tblCa->TableName=dataModelNames->Strings[i]+".db";,  tblU->TableName=uname;,  tblCa->Open();,  tblU->Open();,  tbmU->Execute();,  modelUpdated=true;,  tblCa->Close();,  tblU->Close();,  tblU->DeleteTable(); The TBatchMove mode is set to 'append' of course. I do get key violations using this if they exist. Both computers that I've run this on have huge amounts of both ram and disk storage. The BDE is set as follows: Local Share True, Low Memory Usage Limit 32, Maxbufsize 16384, Maxfilehandles 100, Memsize 42, Minbufsize 4096, MTS Pooling False, Shared Memory Location is blank, Shared Memory Size is 14080, SQLQryMode is blank, Sysflags is 0, Version is 4...

Posted to MB Topic: Paradox Tables « Paradox Board