Android Question Best Practice Question - SQL server

[sulsys]

First, want to say the support in this forum is awesome and the software Anywhere is putting out is really good and Erel seems to be the rockstar, and one willing to help also!

Ok, here goes the background: I am developing an application to be used in the health care field. Each tablet user will need to receive daily updates of data that is currently in MS SQL server. Each user will only receive and update of "their" information. That data will be stored and referenced on the tablet. The users will add data in the form of transactions complete with signatures and potentially lengthy text data. This data they enter needs to be sent back to the ms sql server daily.

Now the questions:

1) What would be the best way to gather the MS Sql data? I have complete control over the server so can pre-filter the data or can do it while connected.
2) What is the best storage method on the tablet? SQLITE?
3) How would I best return the data to the server? I will want to flag transactions as sent so they remain on the tablet but are not sent each time. (That should be easy).
4) Should the data transfer functions be in their own app separate from the data entry app?

Thanks for any suggestions!

Tim

 

[sulsys]

Looks like I am mixing my post and get...

 

[qsrtech]

Yes. B4a http is a post and my experience is you need to grab the query using "form" not query string and don't use the "?" In b4a http. Check my asp script page I posted yesterday.

 

[sulsys]

Checked server logs and can't find any errors. Same with SQL server eventlog (I imagine it didn't get that far)..

 

[qsrtech]

Do a test and just do a response.write(qry) from your asp page where qry=request.form

then in your job done log(job.getstring)

see if that gives you the "qry" you're sending. If so then there's something in your asp page not working correctly.

 

[sulsys]

Good idea.

I did that and it was fine. I looked at your adodb code to get the record set and it was slightly different than mine. I was using a command object as opposed to recordset.open. I Changed to your code and voila the recordset opens. What I still do not understand is the code I had worked just fine when called from the client web browser. The recordset was created and returned (using the get string). Oh well, not going to over think it but it is odd.

thanks again!

 

[qsrtech]

Again probably something to do with the post/get. Anyways next time I give you something, just use it!

 

[qsrtech]

after all these years of sticking with POST I just found out how to do a GET:

http.Download2(Server,Array As String("qry",sql)) 'add more params as needed, i.e. Array As String("qry",sql,"user",AUser,"password",APassword)

 

[sulsys]

That makes sense, I'll give it a try!