Hi All,
This project was (and is) my dream. I dreamed it since when I heard about MySql. I tried with VFP (when I started windows programming from Clipper), but faced problems.
Now, I just started the base of my dream project with HMG. Now, it is very small and very simple. It is so small that you may laugh at my "big" words. Thank you Rathi, you showed me the path.
Please download source code at
This project will create a database "info". When you select an accounting year it will automatically create "infoxxxxyyyy" database, where xxxx is the starting year of accounting period and yyyy is the ending year of accounting period.
Please send your comments. I need them very much to learn HMG and MySql.
With best regards.
Sudip
Starting : Multi Accounting Year with Multi Database
Moderator: Rathinagiri
Starting : Multi Accounting Year with Multi Database
With best regards,
Sudip
Sudip
- Rathinagiri
- Posts: 5471
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
Re: Starting : Multi Accounting Year with Multi Database
Yes, Sudip. We can have separate databases one for the main database and others, one for each year.
Even we can have multiple companies - year wise or multiple years - company wise or multiple years - multiple companies. Back up is also easy. My accounting software is like this.
Even we can have multiple companies - year wise or multiple years - company wise or multiple years - multiple companies. Back up is also easy. My accounting software is like this.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.
Re: Starting : Multi Accounting Year with Multi Database
Thank you Rathi. So, I am in the right track!!! My next target will be a multi-company multi-a/c year software!!!rathinagiri wrote:Yes, Sudip. We can have separate databases one for the main database and others, one for each year.
Even we can have multiple companies - year wise or multiple years - company wise or multiple years - multiple companies. Back up is also easy. My accounting software is like this.
BTW, my old Clipper multi-company software was easily copied. And after that I had a natural tendency to hard code company name (very novice attempt to overcome copy protection). My clients pay a small amount for additional company. I am searching for a better way to do this!!!
With best regards.
Sudip
With best regards,
Sudip
Sudip
- Rathinagiri
- Posts: 5471
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
Re: Starting : Multi Accounting Year with Multi Database
For this reason, I hard code the volume number of the hard disk . They can copy and put in a different hard disk but it won't work.
However, If our client wants to format his hard disk, or changes his system, (s)he requires our help too.
However, If our client wants to format his hard disk, or changes his system, (s)he requires our help too.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.