BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Which Database scheme to use          BorlandTalk.com Forum Index -> C++ Builder (Non-Technical) View previous topic :: View next topic   Author Message Nate Lockwood Guest Posted: Tue Oct 19, 2004 10:06 pm    Post subject: Which Database scheme to use I have a corporate (US Government) credit card for purchases. I've been keeping track of them via spreadsheets but it has been only marginally successful as I need to make meaningful reports to my boss and for paper records so I've been considering using a database to keep track of the transactions, vendor information, etc. It appears that there are several methods to database programming under Builder (I have Builder 6 Pro on an XP machine) and I'd like some advice on which to pursue. If this works for me I intend to make it available to others. Each user will have a database on the user's machine, there would be no sharing over a network. Any suggestions on this? Or if this is not best group in which one should I post? Thanks Nate Back to top William E. Mahaffey Guest Posted: Thu Oct 21, 2004 3:15 pm    Post subject: Re: Which Database scheme to use Nate, I am using NexusDB, http://www.nexusdb.com/, and am very happy with it. Might be a little over kill for what you are doing. It does allow single user and client/server applications. BCB 6, WinXP Pro William Back to top Michael Gillen Guest Posted: Thu Oct 21, 2004 3:43 pm    Post subject: Re: Which Database scheme to use Nate Lockwood wrote: Quote: Any suggestions on this? Or if this is not best group in which one should I post? I also use NexusDB ([url]http://www.nexusdb.com)[/url]. It will also allow you to expand to a much larger architecture if you need to. -Michael Back to top Leroy Casterline Guest Posted: Fri Oct 22, 2004 1:03 am    Post subject: Re: Which Database scheme to use "Nate Lockwood" <RNLcokwood-AT-attglobal.net> wrote: Quote: records so I've been considering using a database to keep track of the transactions, vendor information, etc. I also use NexusDB. Works very well, and they have a free 'lite' version that may meet your needs. It's identical to the commercial version with the following limitations: Maximum of 10.000 records in each table Maximum of 5 tables in a database Connect to one server and one database only No restrictions on distribution. Nexus has an active newsgroup with lots of people who seem willing to help people get started, and their support is wonderful. www.nexusdb.com Back to top Nate Lockwood Guest Posted: Fri Oct 22, 2004 2:37 am    Post subject: Re: Which Database scheme to use "Leroy Casterline" <casterle (AT) ccltd (DOT) com> wrote Quote: I also use NexusDB. Works very well, and they have a free 'lite' version that may meet your needs. No restrictions on distribution. Nexus has an active newsgroup with lots of people who seem willing to help people get started, and their support is wonderful. Thanks to all of you. Do I use Nexus with Builder or is it stand alone? Nate Back to top Arnie Mauer Guest Posted: Fri Oct 22, 2004 3:58 pm    Post subject: Re: Which Database scheme to use "Nate Lockwood" <RNLcokwood-AT-attglobal.net> wrote Quote: I have a corporate (US Government) credit card for purchases. I've been keeping track of them via spreadsheets but it has been only marginally successful as I need to make meaningful reports to my boss and for paper records so I've been considering using a database to keep track of the transactions, vendor information, etc. It appears that there are several methods to database programming under Builder (I have Builder 6 Pro on an XP machine) and I'd like some advice on which to pursue. If this works for me I intend to make it available to others. Each user will have a database on the user's machine, there would be no sharing over a network. Any suggestions on this? Or if this is not best group in which one should I post? Thanks Nate How about MSDE? It offers about the same functionality as SQL Server, but for a limited number of connections. And, it's free. - Arnie Back to top Mike Margerum Guest Posted: Fri Oct 22, 2004 8:05 pm    Post subject: Re: Which Database scheme to use MSDE is an excellent free version of SQL server. It starts to throttle itself after 5 concurrent connections though. Quote: It appears that there are several methods to database programming under Builder (I have Builder 6 Pro on an XP machine) and I'd like some advice on which to pursue. If this works for me I intend to make it available to others. Each user will have a database on the user's machine, there would be no sharing over a network. Any suggestions on this? Or if this is not best group in which one should I post? Thanks Nate Back to top Leroy Casterline Guest Posted: Fri Oct 22, 2004 8:58 pm    Post subject: Re: Which Database scheme to use "Nate Lockwood" <rnlockwoodNO (AT) SPAMpacbell (DOT) net> wrote: Quote: Thanks to all of you. Do I use Nexus with Builder or is it stand alone? You use it with Builder (or Delphi). It's a BDE replacement so it works with all of the normal data-aware controls (and those from 3rd parties as well). As I recall, it's a rewrite of TurboPower's FlashFiler (with vast improvements) by the same people who wrote FF for TurboPower. Back to top Kenneth de Camargo Guest Posted: Fri Oct 22, 2004 9:29 pm    Post subject: Re: Which Database scheme to use Arnie Mauer wrote: Quote: How about MSDE? It offers about the same functionality as SQL Server, but for a limited number of connections. And, it's free. I got late to this game, but I'd strongly suggest Firebird, Interbase's opensourced sibling. -- Ken http://planeta.terra.com.br/educacao/kencamargo/ * this is not a sig * Back to top Leroy Casterline Guest Posted: Sat Oct 23, 2004 7:21 pm    Post subject: Re: Which Database scheme to use "Rodrigo Gómez" <rgomez (AT) tsradio (DOT) com.mx> wrote: Quote: Well.. it's slighty different. The creators of NexusDB were involved in the design and architecture of FlashFiler 2, Thorsten specially, but they didn't write the code. NexusDB is all new code, but it "respects" some of the concepts of FF2. In anycase, it is a great database! Thanks for the correction. It's a great DB indeed. Back to top Jack Hanebach Guest Posted: Sat Oct 23, 2004 10:42 pm    Post subject: Re: Which Database scheme to use Nate Lockwood wrote: Quote: I have a corporate (US Government) credit card for purchases. I've been keeping track of them via spreadsheets but it has been only marginally successful as I need to make meaningful reports to my boss and for paper records so I've been considering using a database to keep track of the transactions, vendor information, etc. Wouldn't it make more sense to get Quicken or Microsoft Money? You can even download your transactions, so no manual track keeping is necessery. Back to top Nate Lockwood Guest Posted: Tue Oct 26, 2004 7:06 pm    Post subject: Re: Which Database scheme to use "Jack Hanebach" <jack.no (AT) spam (DOT) hanebach.net> wrote Quote: Wouldn't it make more sense to get Quicken or Microsoft Money? You can even download your transactions, so no manual track keeping is necessery. No, as the transactions are on an internal db with very limited access. Thanks Nate Back to top rolrolrol@web.de Guest Posted: Sun Oct 31, 2004 8:16 am    Post subject: Re: Which Database scheme to use I am a happy user of DBISAM. A very reliable database which is a TDataSet descendant and integrates perfectly into the Borland world. It is free and easy to check it out, licenses are very reasonably priced and you can distribute without royalities. www.elevatesoft.com Roland Wolf "Nate Lockwood" <RNLcokwood-AT-attglobal.net> wrote: Quote: I have a corporate (US Government) credit card for purchases. I've been keeping track of them via spreadsheets but it has been only marginally successful as I need to make meaningful reports to my boss and for paper records so I've been considering using a database to keep track of the transactions, vendor information, etc. It appears that there are several methods to database programming under Builder (I have Builder 6 Pro on an XP machine) and I'd like some advice on which to pursue. If this works for me I intend to make it available to others. Each user will have a database on the user's machine, there would be no sharing over a network. Any suggestions on this? Or if this is not best group in which one should I post? Thanks Nate Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         BorlandTalk.com Forum Index -> C++ Builder (Non-Technical) All times are GMT Page 1 of 1   Jump to: Select a forum C++ Builder Newsgroups----------------C++ BuilderC++ Builder (ActiveX)C++ Builder (Announcements)C++ Builder (Command Line Tools)C++ Builder DatabasesC++ Builder Databases (ADO)C++ Builder Databases (Desktop)C++ Builder Databases (InterBase Express)C++ Builder Databases (Multi-Tier)C++ Builder Databases (SQL Servers)C++ Builder (Graphics)C++ Builder (IDE)C++ Builder (Internet)C++ Builder (Internet Socket)C++ Builder (Internet Web)C++ Builder (Jobs)C++ Builder (Language)C++ Builder (Language C++)C++ Builder (Compatibility with MFC)C++ Builder (Native API)C++ Builder (Non-Technical)C++ Builder (Students)C++ Builder (Third Party Tools)C++ Builder (Upgrade)C++ Builder (VCL)C++ Builder (VCL Components Usage)C++ Builder (VCL Components Development)C++ Builder (VCL Usage)C++ Builder (WinAPI)C++ Builder Installation Delphi Newsgroups----------------Delphi (General)Delphi ActiveX Controls UsageDelphi ActiveX Controls DevelopmentDelphi As400Delphi DatabasesDelphi Databases (ADO)Delphi Databases (dbExpress)Delphi Databases (Desktop)Delphi Databases (InterBase Express)Delphi Databases (Multi-Tier)Delphi Databases (SQL Servers)Delphi DeploymentDelphi GraphicsDelphi IDEDelphi InternationalizationDelphi InternetDelphi Internet Isapi-WebBrokerDelphi Internet WebSnapDelphi Internet WinsockDelphi JobsDelphi Language BASMDelphi Language ObjectPascalDelphi Model Driven Architecture (General)Delphi Model Driven Architecture (Third Party)Delphi MultimediaDelphi Native APIDelphi Non-TechnicalDelphi ObjectPascalDelphi OLE AutomationDelphi OO designDelphi OpenToolsAPIDelphi Reporting-ChartingDelphi RTLDelphi StudentsDelphi TeamSourceDelphi Thirdparty ToolsDelphi Thirdparty Tools (General)Delphi Thirdparty Tools (IntraWeb)Delphi Thirdparty Tools (RaveReports)Delphi UpgradeDelphi VCLDelphi VCL ComponentsDelphi VCL Components UsingDelphi VCL Components WritingDelphi WebServices SOAPDelphi WinAPIDelphi XMLDelphi Installationcomp.lang.pascal.delphi.components.misccomp.lang.pascal.delphi.components.usagecomp.lang.pascal.delphi.components.writingcomp.lang.pascal.delphi.databasescomp.lang.pascal.delphi.misccomp.sources.delphi JBuilder Newsgroups----------------JBuilderJBuilder AnnouncementsJBuilder Applet IssuesJBuilder As400JBuilder CompilerJBuilder CORBA/RMIJBuilder DatabasesJBuilder DB SwingJBuilder DebuggerJBuilder DeploymentJBuilder DocumentationJBuilder EnterpriseJBuilder HandheldJBuilder IDEJBuilder JavaJBuilder JavaAPIJBuilder Java LanguageJBuilder Java SwingJBuilder Java BeansJBuilder Java Beans UsageJBuilder Java Beans DevelopmentJBuilder JBCLJBuilder JDataStoreJBuilder JobsJBuilder LinuxJBuilder MacintoshJBuilder & MobileSetJBuilder MultiLingual AppsJBuilder Non-TechnicalJBuilder OpenToolsJBuilder Servlets (JSP)JBuilder StudentsJBuilder Team DevelopmentJBuilder Thirdparty ToolsJBuilder UpgradeJBuilder Installation InterBase Newsgroups----------------InterBaseInterBase Bug DiscussionInterBase GeneralInterBase IBConsoleInterBase OpenSourceInterBase ReplicationInterBase SQLInterBase ThirdpartyInterBase Installation Miscellaneous Borland Newsgroups----------------AppCenterAppServerEnteraVisiBroker  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.