microbox Active Member Licensed User Longtime User Sep 11, 2017 #1 Hi everyone! I'm having issue displaying my result query to a webview. Kindly see the image...not really sure what I'm doing wrong.. and is there away I can adjust the width of header to make it neat? Thanks for the time. EDIT: This is my code to produce the result Code: wv1.LoadHtml(DBUtils.ExecuteHtml(SQL, "SELECT * FROM sales Where date = = '" & vDate & "'" ,Null, 0,False)) Last edited: Sep 11, 2017
Hi everyone! I'm having issue displaying my result query to a webview. Kindly see the image...not really sure what I'm doing wrong.. and is there away I can adjust the width of header to make it neat? Thanks for the time. EDIT: This is my code to produce the result Code: wv1.LoadHtml(DBUtils.ExecuteHtml(SQL, "SELECT * FROM sales Where date = = '" & vDate & "'" ,Null, 0,False))
Erel B4X founder Staff member Licensed User Longtime User Sep 11, 2017 #2 There are two equal signs in the query. Upvote 0
microbox Active Member Licensed User Longtime User Sep 11, 2017 #3 Erel said: There are two equal signs in the query. Click to expand... Oops sorry about that..my mistake on copying and pasting but this is the actual code Code: wv1.LoadHtml(DBUtils.ExecuteHtml(SQL, "SELECT * FROM sales Where date = '" & vDate & "'" ,Null, 0,False)) Thanks Erel for replying. Upvote 0
Erel said: There are two equal signs in the query. Click to expand... Oops sorry about that..my mistake on copying and pasting but this is the actual code Code: wv1.LoadHtml(DBUtils.ExecuteHtml(SQL, "SELECT * FROM sales Where date = '" & vDate & "'" ,Null, 0,False)) Thanks Erel for replying.
Erel B4X founder Staff member Licensed User Longtime User Sep 11, 2017 #4 1. Make sure to use the latest version of DBUtils: https://www.b4x.com/android/forum/threads/b4x-dbutils-2.81280/ 2. Assuming that you are then please upload the database file. Upvote 0
1. Make sure to use the latest version of DBUtils: https://www.b4x.com/android/forum/threads/b4x-dbutils-2.81280/ 2. Assuming that you are then please upload the database file.
microbox Active Member Licensed User Longtime User Sep 14, 2017 #5 Thanks Erel, Works great now ..but another question is how can I adjust the width of the column? Upvote 0
DonManfred Expert Licensed User Longtime User Sep 14, 2017 #6 microbox said: how can I adjust the width of the column? Click to expand... by changing the html code the class is generating Upvote 0
microbox said: how can I adjust the width of the column? Click to expand... by changing the html code the class is generating
microbox Active Member Licensed User Longtime User Sep 14, 2017 #7 DonManfred said: by changing the html code the class is generating Click to expand... Hi DonManfred...I will try it. Thanks Upvote 0
DonManfred said: by changing the html code the class is generating Click to expand... Hi DonManfred...I will try it. Thanks