One way to do this is to make your stack a standalone client application which you distribute to your co-workers. If the standalone connects to any of the standard databases -- MySQL, PostgreSQL, etc. -- the database will handle the multiple connections for you so that nobody overwrites someone else's data. To communicate with the database you might use Trevor Devore's new SQL Yoga library ($ from RevSelect) or his earlier free libDatabase (http://www.bluemangolearning.com/revolution/software/libraries/libdatabase/ ). The client application could also use the database connection to retrieve and display the current data.

George

On Oct 3, 2009, at 10:22 AM, Javier Miranda V. wrote:

Hi amigos, I would like to describe an scenario. If you can, please outline how it can be resolved using Revolution:

I would like co-workers (initially in the LAN), fill a variety of forms, that later can be retrieved, searched, printed etc. I believe that connecting Revolution with a database manager using ODBC is the way to go, but how stack will be opened in the LAN simultaneously by more than one user?. In one machine I may have to put the stack connected to the database manager, and in each of the clients machine a stack connected to the RR stack in the server? or maybe each client should connect to the DB?. Scale this to reach the data thru Internet would be fabulous but for now working in the LAN would be sufficient.

Hope all this make sense and you can give me a clue, you may have noticed that I´m really lost with this.

Saludos,




Javier_______________________________________________
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

_______________________________________________
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
  • Scenario Javier Miranda V.
    • Re: Scenario George C Brackett

Reply via email to