Starting : Multi Accounting Year with Multi Database

[sudip]

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.

InfoSql001.jpg (25.64 KiB) Viewed 17465 times

Please download source code at

InfoSql.zip

(6.71 KiB) Downloaded 967 times

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

[Rathinagiri]

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.

[sudip]

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.

Thank you Rathi. So, I am in the right track!!! My next target will be a multi-company multi-a/c year software!!!

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

[Rathinagiri]

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.