Need help figuring out a fast and efficient way to update a B4XTable* with websocket data.
I'm exploring algorithms right now for getting the updated data into the B4XTable.
It would be great if when I updated some collection (i.e., a map, custom type, etc.), the B4XTable would automatically update as well. Is that kind of functionality possible? myMap_Updated()? ?
Otherwise, if anybody has any good ideas, please share!
Example of the JSON string I receive from the websocket:
I'll need to update the row corresponding to the "pair" value. The columns are updated with the "asks" and "bids" data.
It seems the step-by-step would be:
Thank you!
* If there's a better grid view, I'm willing to try it!
I'm exploring algorithms right now for getting the updated data into the B4XTable.
It would be great if when I updated some collection (i.e., a map, custom type, etc.), the B4XTable would automatically update as well. Is that kind of functionality possible? myMap_Updated()? ?
Otherwise, if anybody has any good ideas, please share!
Example of the JSON string I receive from the websocket:
B4X:
{"exchange":"binance","pair":"eth-btc","channel":"orderbook","snapshot":true,"sequence":849,"content":{"asks":[{"price":"0.08363500","quantity":"2.21140000"}],"bids":[{"price":"0.08418600","quantity":"5.47350000"}]}}
I'll need to update the row corresponding to the "pair" value. The columns are updated with the "asks" and "bids" data.
It seems the step-by-step would be:
- Get the row to be modified (find it with "pair")
- Get the column(s) to be modified ("content" contains the values I need)
- Use B4XTable1.sql1... to update the underlying sqlite record
- Use B4XTable1.UpdateTableCounters
Thank you!
* If there's a better grid view, I'm willing to try it!