Sqlite - Mysql Sending Data

Sytek

Active Member
Licensed User
Longtime User
Hi, botthering you again
I want to send a sales data detail throught HttpClient library.

I don't have problem inserting over sqlite, querying data over the httpclient. (mysql) That's just fine.

My problem is when i want to "check" the stock list products quantity
Here's what i'm doing.
I have in my database this Details
Ct ct ct ct
BEAN001
Testtesttest

Those are the code products

This is a Button
Dim Cursor1 As Cursor
SQL1.Initialize(Main.datafiles,"invdetail.db",True)
Cursor1 = SQL1.ExecQuery("SELECT * FROM invdetail")
For i = 0 To Cursor1.RowCount - 1
Cursor1.Position = i
clvproduct=Cursor1.GetString("clave")
Log("Producto "&clvproduct) 'This one returns as follows
'Producto Ct ct ct ct
'Producto BEAN001
'Producto Testtesttest
ProgressDialogShow("Verificando Inventario de Producto "&clvproduct)
FetchProductsList
Next
Cursor1.Close

In the Log when i call the FetchproductsList just appears me the last one

Response from server: [{"id":"2","clave":"Testtesttest","descripcion":"More.more","existencia":"50"}]

I don't know if this is the correct method, but would you please help me?

Thanks in advance
Sytek
 

poseidon

Member
Licensed User
Longtime User
(?)

FetchProductsList 'this executed for each record, because is in for..next
Next

as a result to show the last one
 
Upvote 0

Sytek

Active Member
Licensed User
Longtime User
Hi poseidon thank's for your reply

I'm not asking why FetchProductsList is in my Log everytime the for...next is running, i'm asking why the last product in the cursor is only displayed.

see.
I have three records in my database but only one is showing on the log
Response from server: [{"id":"2","clave":"Testtesttest","descripcion":"Mo re.more","existencia":"50"}]

...The other two are missed
If my query where wrong the response could be like this

Response from server: []
Response from server: []
Response from server: [{"id":"2","clave":"Testtesttest","descripcion":"Mo re.more","existencia":"50"}]

I need to send the rest 2 of them

Regards
Sytek
 
Upvote 0

Sytek

Active Member
Licensed User
Longtime User
explain more as

Quote:
I have a server that sends...

I have a mob app that...
Sqlite - Mysql Sending Data
Hi, bothering you again
I want to send a sales data detail throught HttpClient library.

I don't have problem inserting over sqlite, querying data over the httpclient. (mysql) That's just fine.
That for me is an Android Device trying to send data over HttpClient

I'm sorry but did you need more info?
 
Upvote 0
Cookies are required to use this site. You must accept them to continue using the site. Learn more…