DBUtils - Android databases are now simple!

[Erel]

I guess that the emulator you set was configured without a storage card. Create a new emulator (AVD) and set the storage card size to 16mb.

[Ricky D]

my new username wouldn't work for some reason.

This is my old one from my b4ppc days on my win phone 6.1 lol

I recreated the emulator and it works. Thanks

regards, Ricky

[Ricky D]

I am wondering what the list argument in the call is? I've tried to search but it's not anywhere.
Regards, Ricky

[Erel]

You can open the DBUtils module and see the method (or you can select the method and press F7 to get to the method or you can press Ctrl + E and write this method name).

See this post for more information about the "clickable" parameter: http://www.basic4ppc.com/forum/basic...html#post50625

[splatt]

In the ExecuteHtml sub routine, I assume the width of the columns is based on the column name. Is it possible to make this width greater, so that longer text items display in a more readable way?

[Erel]

The width is set automatically by WebView. It considers both the title and the cells text.

If you want to manually set the width you can modify ExecuteHtml sub.
For example to set the second column width you can use this code:

For i = 0 To cur.ColumnCount - 1
        If i = 1 Then
            sb.Append("<th style='width:200px;'>").Append(cur.GetColumnName(i)).Append("</th>")
        Else
            sb.Append("<th>").Append(cur.GetColumnName(i)).Append("</th>")
        End If
    Next

[splatt]

I tried this and it did not make any difference.

The resulting table has three columns of equal width, which appears to be dictated by the width of the webview.

Is it possible to produce wider tables, as we have the ability to zoom in or out anyway?

[Erel]

The table width is set by the value of HtmlCSS variable.

[splatt]

Excellent. Thanks for that Erel. I've set my report width to 150% and it works fine now.

[Penko]

Erel, what is the reason to lowercase the database field names in ExecuteMap?

I was searching for an error in my code until I used Log for my map object only to see that my key is "list" instead of "LIST".

I am just asking if there is any reason to do so provided that I use uppercase fields when designing databases(no matter MySQL, SQLite or anything else) because it's easier to read them(at least for me).

Of course I can pass the lowercase value of my name but I wondered why is this?

Edit: I have another question. By returning "Null" in various occassions, what is the best way to get my results? I've used:

txtFileName.Text = values.Get("list")
    txtNotes.Text = values.Get("notes")

This crashes when my database field is empty. I had to apply the following change to DBUtils in order to make it return a blank string which won't crash my application.

Dim val As Object
    
    For i = 0 To cur.ColumnCount - 1
    
    val = cur.GetString2(i)
    
    If(val = Null) Then
        val = ""
    End If

        res.Put(cur.GetColumnName(i).ToLowerCase, val)
    Next

Unfortunately, it won't work for INTEGER.