I.T. Discussion Community!
-Collapse +Expand
shedden
-Collapse +Expand Profile◄╣
Computer community for power-users and I.T. professionals!
Personal Account . . .
jrshedden
Kinnelon, -- UNK
Rank: Cadet 3rd Year
Send New Private Message Send Message   Add ContactAdd To Friend List Block Member Block Member
Real Name:  James Shedden
Joined: Feb 2010 (50 months ago)
Visits: 7
Member Points28
Primary Role:  Coder
Location:  Kinnelon, NJ USA

Message Boards Activity

3 posts.
More...

Thread 3 of 3
Thread Starter or a Reply (but not last)  Group

jrshedden
BDE GetConfigParams Block Size
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
42 months ago
Nothing New Since Your Last Visit
2443
Hits

C++

Thread 2 of 3
Thread Starter or a Reply (but not last)  Group

jrshedden
Paradox 3 table add
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
46 months ago

shedden
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();,  modelU...
46 months ago
Nothing New Since Your Last Visit
2260
Hits

Corel Paradox / ObjectPAL Coding

Thread 1 of 3
Thread Starter or a Reply (but not last)  Group

jrshedden
Methodology
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
46 months ago
Nothing New Since Your Last Visit
Corel Paradox / ObjectPAL Coding
-
  Load Time=1 seconds.
 
Print This


-
 
Have a question? Need our services? Contact us now.
--Mike Prestwood

Call: 916-726-5675

email: info@prestwood.com


1,326 People Online Now!!  
Sign In to see who's online now!  Not a member? Join now. It's free!
Show more stats...
Follow PrestwoodBoards on: 


©1995-2014 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech