Hello, i have a small amount of coding skills in android development but most of the time i can look at tutorials online and work around it too make it work my boss wants it too work. basically i have been trying for weeks to be able to get data from our oracle server to a list view and i have not had any success. i am able to retrieve the data fine as it just displays into a text field but it would look nicer if it was inside of a list view which i hope you can help me with. there is one problem i am not able to test to see if the code would work unless i am at work as it only works when you are on the local network.
so to sum it all i got the data i need from the oracle server but i want too display it into a list view and not a text field. i know this may sound stupid too ask for probably something really simple here is a sample code i have.
try {
Statement stmt = null;
String sql = null;
stmt = [login to view URL]();
sql = "Select c.client_name, c.client_code, p.product_id, p.scan_id, p.case_bar_code, p.prod_title, p.ean_upc_id" +
"l.loc_code, l.product_qty, l.request_from_qty, l.request_in_qty" +
" from clients c, products p, prod_locations l" +
" where c.client_code=l.client_code" +
" and p.client_code=l.client_code" +
" and p.product_id=l.product_id" +
" and (p.product_id = '" + [login to view URL]().toString() + "'" +
" or p.scan_id = '" + [login to view URL]().toString() + "'" +
" or p.case_bar_code = '" + [login to view URL]().toString() + "'" +
" or p.prod_title like '%" + [login to view URL]().toString() + "%'" +
" or p.ean_upc_id = '" + [login to view URL]().toString() + "')";
ResultSet rs = [login to view URL](sql);
while ([login to view URL]()) {
String client_name = [login to view URL](1);
String client_code = [login to view URL](2);
String product_id = [login to view URL](3);
String scan_id = [login to view URL](4);
String case_bar_code = [login to view URL](5);
String prod_title = [login to view URL](6);
String ean_upc_id = [login to view URL](7);
String loc_code = [login to view URL](8);
String product_qty = [login to view URL](9);
String request_from_qty = [login to view URL](10);
String request_in_qty = [login to view URL](11);
[login to view URL]("Client: " + client_name + " | " + "Product ID: " + product_id + " | " + "Desc: " + prod_title + " | " +
"LOC: " + loc_code + " | " + "QTY: " + product_qty + " | " + "Req In: " + request_in_qty + " | " + "Req Out: " + request_from_qty + "\n\n");
}
[login to view URL]();
} catch(Exception e) {
Log.e("onCreate", "Error ", e);
[login to view URL]("Error " + e);
}