Hi, I can connect to the database from another device?
You only need a webhosting (a few $/month) with the possibility for accesing a Database from outside. Then you just can use my MySQL-Library to connect to the db. My or any other mysql-connectors. There are some of them... For example i pay 10,-/Month for my webhosting with 50GB webspace and my Databases are accessible from outside so i can use them directly in my app.Not force the customer to buy a PC server.
NoCan you choose a different database than MySQL?
do i know you software?Do I need to change a lot in my current software?
... that's true.No
MySQL speaks mostly the same language. SQL.
do i know you software?
cFormaPagoNom = globales.DBconex.ExecQuerySingleResult2("select nombre from tbFormasPago where codigo=?",Array As String(iFormaPagoCod)) cSql = "Select ga.codigogrupo from tbGruposArticulos ga inner join tbGrupos g on g.codigo=ga.codigogrupo order by g.orden limit 1" cMinGrupo = globales.DBconex.ExecQuerySingleResult(cSql) cSql = "update "&cTBcab&" set numeromesa=?, codigosalon=? where id=?" globales.DBconex.ExecNonQuery2(cSql,Array As String(iMesa,iSalonCod, iID)) cInsert = "insert into "&cTBlin&" (idcabecera,linea,tiposerienumerocabecera,codigoempleado,codigoarticulo," cInsert = cInsert & "nombrearticulo,cantidad,precio,ivacod,ivapc,repc,ivaimporte,reimporte,sumalinea," cInsert = cInsert & "estadolinea) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)" globales.DBconex.ExecNonQuery2( cInsert, Array As Object( iIIDnew, QN.GetInt("linea"), iTip&cSNnew, _ QN.GetInt("codigoempleado"), _ QN.GetString("codigoarticulo"), QN.GetString("nombrearticulo"), _ QN.GetDouble("cantidad") * (-1), QN.GetDouble("precio"), _ QN.GetInt("ivacod"), QN.GetDouble("ivapc"), _ QN.GetDouble("repc"), QN.GetDouble("ivaimporte") *(-1), _ QN.GetDouble("reimporte") *(-1), QN.GetDouble("sumalinea") *(-1), _ QN.GetInt("estadolinea")))
Can you explain what that is?The most you need to change your app working async... If it working with async methods now (RDC for example) then you dont need to change much i believe. But it is hard to say without seeing the code
Too complex for me. I need help with an example. PleaseActually it seems to be intended to be used in house with no access to the world.
Therefore I would do it like this concept :
1)Setup a server app on one device. This includes the database. Server app means a winsock which is listening on a port. If a client is sending a request the server app opens a new winsock for sending the reply to the client. The server sends the reply to the remote port given by the request. Authentication have to be done for any request.
2)setup a client on a remote device. Actually almost the same but you may keep it with one winsock.
3)Make sure that the conversation is secure by encryption.
If you don't know how to start, than try to get knowledge how chat proggies are working.
You have to insert only a sql section for fetching the data before sending the reply back.
I hope that helps.