FM vs VB.net vs SQL vs Dataease

[jtwilber]

My business runs on an app I wrote with Dataease (Dos dinasaur). Hundreds of forms, dozens of relationships, hundreds of queries. Orders, Invoices, Routing, Employees, Inventory, customers, etc.. I enjoy programing and want to start on the right software to replace all of this. How do I decide if FM is adequate (seems most simple) or if I would be better off starting on VB.net or other types of more "programing" languages... any help very much appreciated.

Wandering in Massachusetts.

[Anatoli]

I am sure FM will do.

The only serious limit in FM 5-6 is max 50 open databases/files. Everything else is basically without limits.

How big is your business? I've just returned from US, where I was helping with FM for international company with 50-70 users and turnover $60 millions.

[jtwilber]

Thanks Anatoli... This is a small company 10 users max. My understanding of the term "database" is different from my "DataEase" programing which called my application a single database (containing 50-70 files or tables of information).

It is my understanding that in FM a single table (ie customer list or inventory list or parts list or emploee list or order or order lines) is considered one database. Does this mean that in FM you can only have up to 50 files or tables.. or does it mean that it can you can only have 50 "related files" open at one time?

[Anatoli]

Yes and no. In single instance/client it can be only 50 databases/tables opened. Server can open 125 files for clients. But you can dynamically open and close files/databases as needed.