[RESOLVED] VB6 - Would like help translating a Dutch program, Query Assistent, to English

[Peter Swinkels]

Introduction:
"Query Assistent" is a program that attempts to make executing SQL queries on any database supported by the Microsoft ADO installation on a specific system faster and easier. It has been tested on/used with the following database types: plain text, Microsoft Access, IBM DB2, and SQL Server. It can export the data to a Microsoft Excel or text file, which if required is attached to an automatically generated e-mail. This program was made because I got tired of having to execute and often slightly modify SQL queries on various databases using clumsy interfaces such as a terminal emulator. Copying and pasting the results into another program often was not that easy either. There already are a few people using this program who think it makes it easier for them to perform these tasks.

Once the program is configured, anyone, even with limited SQL/database knowledge, should be able to do the following with little effort:

1. Start the program using the specified or default configuration file.
2. Connect to the database specified in the configuration file.
3. Load an SQL query, if none has been specified.
4. Specify parameters defined in the query if necessary.
5. Execute the query and view the result.
6. Export to result to a file.
7. Generate and send an e-mail with the result attached.

All the above steps can be fully (or nearly so) automated by:
-Automatically connecting to a database when no password and/or username have to be specified.
-Allowing the user to specify a configuration file and/or query file as a command line argument.
-Allowing the user to define parts of the SQL code as parameters, which are replaced with the user's input before execution.

Request:
Due to the reason this program was initially made, all text, variable/constants/procedure names, comments, and documentation are completely written in Dutch, which severely limits the number of potential users. The entire program could be translated into English, but I would also like to preserve the Dutch version, which would leave me with two versions of the same program to maintain, which also is rather large (100kb of code) and complex. Any suggestions as how to go about translating the program are welcome.

A file called qa.v1.37.zip has been attached, it contains:
-The source code.
-The manual.
-Two sample queries.
-A sample configuration file.

To use the example:
-Compile Qa.vbp using vb6.
-Move the resulting file Qa.exe into the "voorbeelden" folder.
-Drag Biblio.ini over the executable. This will start the program using Biblio.ini's configuration.
-You can also rename Biblio.ini to Qa.ini (default name) and simply start the program as normal.

NOTE:
You will also need Biblio.mdb, the sample database that comes with vb6.

[Peter Swinkels]

Post removed.

[Peter Swinkels]

I'm going to continue this on my own.

[snortop]

maybe you could fine these place usefull

http://crowdin.net/

[Peter Swinkels]

maybe you could fine these place usefull

http://crowdin.net/

I will have a look. Thank you.