javascript - A simple database for an HTA - Stack Overflow

admin管理员组

文章数量:1318582

I have been tasked with creating a couple of databases for local use in our office, one for logging sickness calls and another for logging staff taxis.

I do not have the ability to install new software on the machines that will be used to develop the app nor on the machines that will use the app, so no xAMP based application, unfortunately. Excel is available, but I'd rather not go down that route as I want to provide a clean UI.

So I'm looking at putting together an HTA based application. The question is: I cannot seem to find a simple, easy to use database-type storage solution for an HTA application. Do I need to write something from scratch, or can anyone remend something I can use?

I have been tasked with creating a couple of databases for local use in our office, one for logging sickness calls and another for logging staff taxis.

I do not have the ability to install new software on the machines that will be used to develop the app nor on the machines that will use the app, so no xAMP based application, unfortunately. Excel is available, but I'd rather not go down that route as I want to provide a clean UI.

So I'm looking at putting together an HTA based application. The question is: I cannot seem to find a simple, easy to use database-type storage solution for an HTA application. Do I need to write something from scratch, or can anyone remend something I can use?

• javascript
• hta

Share Improve this question Follow edited Apr 30, 2012 at 16:02 user257111 asked Dec 16, 2010 at 16:04 kaigohkaigoh 50033 silver badges1111 bronze badges

Add a ment  | 

4 Answers 4

Sorted by: Reset to default 3

You can try an SQLite ActiveX wrapper, like SQLite COM or SqLite2X.

If you can't install anything...

• You should be able to connect to a ... dun dun dunnnn ... Access database using ADODB.Connection - VBScript example here, but the API should be portable to JScript, e.g. http://www.kuro5hin/story/2005/7/14/13942/7643

• Quick and dirty idea - store everything in a JavaScript Object and read/write JSON to/from a file.

You can also use XML, with smthn like this: http://msdn.microsoft./en-us/library/ms762708%28VS.85%29.aspx

but in my opinion, MDB(msaccess database) is the best way:

• no external requirements in xp,vista,sevent and 8
• it is a real DB (triggers,indexes)

You can use something like Ragic, instead of writing something from scratch. You really don't have to code anything, and your coworkers wouldn't be too perplexed, as it uses a spreadsheet interface like Excel. Also, it's a cloud database on the web, so you won't have to install on the office puters.

本文标签： javascriptA simple database for an HTAStack Overflow