DBUtils HTML Table

B

BrutalSnyper

Member
Licensed User
Longtime User
I'm trying to show a table of the records in my database on the second tab of my TabHost but the table does not show and I cannot work out why not.

Here is my code:
B4X: 
Sub tbhPages_TabChanged
   If tbhPages.CurrentTab = "2" Then
      ShowTableInWebView
   End If
End Sub

Sub ShowTableInWebView
   WebView1.Visible = True
   
   WebView1.LoadHtml(DBUtils.ExecuteHtml(SQL1, _
   "SELECT NameOfNote, NoteText FROM Notes" _
   , Null, 0, True))
End Sub
 
Sort by date Sort by votes
B

BrutalSnyper

Member
Licensed User
Longtime User
In the designer on the second tab I added the WebView and it is declared.

I don't want to post the project zip file as I do not want to lose all of the work I've done by somebody stealing my application and idea and selling it on the Android Market themselves.
 
Last edited:
Upvote 0
K

kickaha

Well-Known Member
Licensed User
Longtime User
1) does ShowTableInWebView get called
2) does "SELECT NameOfNote, NoteText FROM Notes" return results
3) if you add a basic web page to WebView1 does it display correctly
 
Upvote 0
B

BrutalSnyper

Member
Licensed User
Longtime User
1) The table shows when I run ShowTableInWebView on application startup, but not when it's in the tab change module.
This should be sufficient. Thanks.
2) It's currently showing the titles of the columns in the table but not the data, I'm not sure if that is because there is no data or there is a problem with the query.
3) I'll try that now.
 
Upvote 0

klaus

Expert
Licensed User
Longtime User
In the designer on the second tab I added the WebView and it is declared.
Click to expand...
How did you add the WebView on Tab2 in the Designer ?
You need to add it in the code with TabHost1.AddTab.
The attached demo program shows an example.

Best regards.
 

Attachments

  • TabHostWebViewHTML.zip
    13 KB · Views: 334
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Solved
Android Question B4A DBUtils.COPYDB
Replies
4
Views
2K
JonnyCav
  • Article
B4A Library [B4X] MiniHtmlParser - simple html parser implemented with B4X
Replies
8
Views
10K
Erel
  • Article
B4J Library [B4X] DBUtils 2
2 3 4
Replies
76
Views
61K
Fizzy
F
M
  • Article
B4A Library [Class] Flexible Table
64 65 66
Replies
1K
Views
377K
RB Smissaert
R
  • Article
B4A Library [Class] TableView - Supports tables of any size
18 19 20
Replies
381
Views
207K
advansis
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…