My app will have the user enter a UserName/PW from my B4A app before he can connect to the remote database. When the remote server authenticates the user as being valid (by using UserName_PW table), a session id is generated and a row is added to a temporary table on the server showing the user is connected and authenticated. The remote server then needs to pass this session id back to the client.
The session id can be a string or part of a Type. Passing a Type back and forth would be better because I could pass more info.
Server to Client:
1) Should I modify the DBResult Type and add another string variable to hold the SessionId? Or is there a Tag I could use that gets passed to the remote server automatically?
Client to Server:
2) The client app also needs to pass this same session id back to the remote server on every request so the server knows the user has been previously authenticated so it will allow access to the database. I don't see a simple way to pass the session id (or type) from the client back to the remote server. I suppose I could pass it as a query parameter that gets removed before any SQL is executed on the server but I am hoping there is a better way.
Does anyone have any ideas?
TIA
The session id can be a string or part of a Type. Passing a Type back and forth would be better because I could pass more info.
Server to Client:
1) Should I modify the DBResult Type and add another string variable to hold the SessionId? Or is there a Tag I could use that gets passed to the remote server automatically?
Client to Server:
2) The client app also needs to pass this same session id back to the remote server on every request so the server knows the user has been previously authenticated so it will allow access to the database. I don't see a simple way to pass the session id (or type) from the client back to the remote server. I suppose I could pass it as a query parameter that gets removed before any SQL is executed on the server but I am hoping there is a better way.
Does anyone have any ideas?
TIA