Skip to forum content
FrontAccounting forum
It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
Active topics Unanswered topics
Search options
A requirement which has some similar elements is the selling of domain registrations for example. Many identically priced, but unique items. The name of the domain can be considered to be similar to the serial number.
Some of this functionality can be achieved by adding a "Price" field to "Item Categories".
Hope that makes some sense.
Fiscal years seem to have to be consecutive with no days missing, they can be longer than 1-year however. Try entering a very long fiscal year, starting whenever and ending on the 31-03-2010. Then you will be able to add the year you describe and delete the earlier years. Worked for me anyway (with 2.3RC3).
The only sensible way to proceed IMHO is to place all the database calls into a single file or set of files.
Currently you're not making abstraction very easy!
MySQL calls occur in:
admin/system_diagnostics.php, admin/inst_upgrade.php, includes/db_pager.inc, includes/current_user.inc, install/save.php,
as well as the includes/db/ directory.
That's with V2.2.11 BTW.
I'd be more than happy to conribute to a SQLite driver once the calls are lumped together. I'd recommend the PDO interface too.
With MySQL now owned by Oracle the future of the database must be uncertain. Tying yourself to this storage engine doesn't look wise to me.
I'd like to use SQLite.
If you want an example of DB abstraction that supports MySQL, SQLite and PosgresSQL; look no further the Drupal 7. Yes, they have just added support for the other two DBs.
MySQL functions seem to be in all sorts of places, as a seach for "mysql_" reveals.
I'd like to use SQLite. I'd write the abstration layer which would be quite simple were it not for the above.
Posts found: 6