How to get the list of all updated and Not updated row of Data base from server ?
-
I have implemented the code where i get the data using API. Now during data receiving if we receive from 1 to 999 rows instead of 1 to 1000 row due to network issue. i have to try again by sending api to receive 1 to 1000 row of database's table.
actually i need to try again for receive 1000 th row only. But how to do it ? i don't know how to receive only remaining rows which not get due to network issue using sqlite based query in c++ ?
It take to much time for only one row.
-
I have implemented the code where i get the data using API. Now during data receiving if we receive from 1 to 999 rows instead of 1 to 1000 row due to network issue. i have to try again by sending api to receive 1 to 1000 row of database's table.
actually i need to try again for receive 1000 th row only. But how to do it ? i don't know how to receive only remaining rows which not get due to network issue using sqlite based query in c++ ?
It take to much time for only one row.
@Qt-embedded-developer
Do you mean: You have an API, which we know nothing about, and you wish someone to tell you how to retrieve only selected data from it?Or, do you mean your API is an interface to SQL statements to retrieve rows from a database? And you want to know how to retrieve a single row using SQL (SQLite)?
Finally, I do not understand how you get a "network issue using sqlite based query"? I thought that SQLite is only for local files, not network ones? In any case, I would worry more about any network issues themselves. If you have network issues affecting database row retrieval I don't see how you can use that approach reliably.
-
@Qt-embedded-developer
Do you mean: You have an API, which we know nothing about, and you wish someone to tell you how to retrieve only selected data from it?Or, do you mean your API is an interface to SQL statements to retrieve rows from a database? And you want to know how to retrieve a single row using SQL (SQLite)?
Finally, I do not understand how you get a "network issue using sqlite based query"? I thought that SQLite is only for local files, not network ones? In any case, I would worry more about any network issues themselves. If you have network issues affecting database row retrieval I don't see how you can use that approach reliably.
@JonB i am using curl library and Soap API to send request and response. Now curl library internally use my sim card network. Now when sim card Not has network at that time this type of situation get raise.
Now when i receive the soap response i split that response and store into sqlite data base table.
I hope my explanation is enough.
-
@JonB i am using curl library and Soap API to send request and response. Now curl library internally use my sim card network. Now when sim card Not has network at that time this type of situation get raise.
Now when i receive the soap response i split that response and store into sqlite data base table.
I hope my explanation is enough.
@Qt-embedded-developer
As clear as mud. So what is your actual question? Is it a SQL/SQLite question about doing aSELECT, or something else? (Not that I even understand how SQLite is involved here or where it runs or how it can return 1 row less than yourSELECT, or anything else.) You really need to explain what kind of an answer you are looking for....
