Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Thursday, April 25, 2019 
 
dBase Table Splitter  
Description:  This utility allows you to split a dBase table with several fields down into smaller tables. Some applications that use the BDE dbi APIs, Codebase, or other dBase engines, will allow a dBase table to contain more than 255 fields. This causes a problem when trying to read the table from applications that use BDE via a Delphi layer, the Microsoft dBase Driver, or even via your own application using ADO.

Category:  Utilities
Author:  Ryan Farley
Submitted:  12/4/2002
   
Stats: 
Article has been read 4914 times

Rating: - 5.0 out of 5 by 3 users
 

fiogf49gjkf0d
dBase Table Splitter

This utility allows you to split a dBase table with several fields down into smaller tables. Some applications that use the BDE dbi APIs, Codebase, or other dBase engines, will allow a dBase table to contain more than 255 fields. This causes a problem when trying to read the table from applications that use BDE via a Delphi layer, the Microsoft dBase Driver, or even via your own application using ADO. You'll find that many times the Contact2 table from GoldMine will fall into this category. Too many fields/columns. Not even SQL DTS will be able to read it. This utility will split the columns in the table into seperate tables in an Access database and copy to each table the primary ID field from the original dBase table.

Here is a screenshot:



 Click here to download the utility

VB 6 Runtimes required

-Ryan Farley
 

About the Author

  Ryan Farley
(SalesLogix Business Partner)
Customer FX Corporation

fiogf49gjkf0d

Ryan Farley is the Director of Development for Customer FX and creator of slxdeveloper.com. He's been blogging regularly about SalesLogix since 2001 and believes in sharing with the community. He loves C#, Javascript, Python, web development, open source, and Linux. He also loves his hobby as an amateur filmmaker.

View Ryan's SalesLogix Mobile Seveloper Series
View Ryan's SalesLogix SData Developer Series
View Ryan's Git for the SalesLogix Developer series



View online profile for Ryan Farley
 

[ back to top] [ send to a friend]  

Rate This Article you must log-in to rate articles. [login here] 
 
Please log in to rate article.
 

Comments & Discussion you must log-in to add comments. [login here] 
 
Article does not have any comments. Be the first to comment by clicking the 'add comment' link above!  

       Visit the slxdeveloper.com Community Forums!
Not finding the information you need here? Try the forums! Get help from others in the community, share your expertise, get what you need from the slxdeveloper.com community. Go to the forums...
 



 slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation.
 This site, and all contents herein, are Copyright © 2019 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.

code of conduct | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 4/25/2019 7:55:16 AM