Is this application possible?

Hi everybody:

I know how powerful MMF2 is for games and also for Apps.

What I want to know, is if a Windows application like the screenshot attached is possible to make in MMF2.

Basically, is for making an employees database with names, phones, address, salary, date entering the company, date leaving the company (when they don't work there anymore), photo, etc.

I guess it is possible but, will it be to hard to program? How can I save the information entered for each employee? And how to just "open" this info in another frame without being able to edit?

Thanks a lot!

Attachment 15684

Yes it is possible. You can use sqlite pro object to save/load data.

As Coldfire says SQLite is a good option for this. Your app doesn't appear to be too complex so SQLite should work fine. You can also use the ODBC object to load a MDB file if you preferred. Both use query language commands.

I wouldn't go using arrays or a custom binary data file format. A query language database is definitely the way to go. They also have multi client support.

So I would recommend doing some reading on SQLite or MDB (Microsoft Access DB format). Get familiar with adding/removing/updating data to the database using queries. You can then apply that knowledge to making your app.

Alternatively you could make such a thing in something like Microsoft Access (the design will need MS Access but clients can use the Access runtime which is free) or Filemaker. But where's the challenge in that?

Just curious; what advantages would SQL have over an array or binary data file?

Super easy here are some tutorial you can follow, they're for entering highscores but you can easy use them for whatever type of data:

http://community.clickteam.com/threads/87185-Online-High-Score-Tutorial

http://community.clickteam.com/threads/89339-Online-Database-with-Clickteam-Fusion-2-5-GET-object-and-String-Parser
How to save data local
http://community.clickteam.com/threads/89685-Save-Data-INI-Strings-Numbers-Object-Position-Tutorial

SQL / HTML5
http://community.clickteam.com/threads/89440-Highscore-Tutorial-on-HTML5-Access-Control-Allow-Origin-CORS

http://community.clickteam.com/threads/89382-HMTL5-connect-to-online-DATABASE

http://community.clickteam.com/threads/89377-Deleting-Records-From-mySQL-Database-using-fusion

http://community.clickteam.com/threads/89350-Database-with-Clickteam-Fusion-2-5-Insert-New-Records

X)

The SQL engine does the look ups on the data. If you wanted to search a binary data file for all users aged 30 or older for example you would need to parse through each record for it. If you were using a binary file. With SQL you just use a query like "select * from myTable where age >= 30;" It'll only return with the records of users that are 30 or older. So less work for your app to do.

Here are just a few reasons to use SQL for a database:

SQL will be faster.
SQL will be easier to implement.
The chances of corruption of Binary datafiles is much higher than SQL. (SQL is pretty much no chance of corruption)
SQL allows multiple clients to update the database at the same time.
SQL can have transaction logs so that you can roll back changes.
SQL Tables can easily have additional columns added with little changes to be made to your app. If you decided to add a column in a binary data file you'll have a job on your hands.

These are just a few reasons why you should go down the query language route.

Binary has it place. For saving game's and such. But I wouldn't use it for database storage.