Android Question ContactsUtils lib cannot add pnone

[hzytsoft]

i use
[class] ContactsUtils - Provides read / write access to the stored contacts

link:http://www.b4x.com/android/forum/th...ad-write-access-to-the-stored-contacts.30824/

but
i use this code
Dim c As cuContact

c=cu.InsertContact("jim","1234567890")
ToastMessageShow(c.Id, False)
cu.AddPhone(c.Id,"87909877","home")
but got wrong
then i use this code
cu.AddPhone(c.Id,"87909877","1")

also got wrong
===============
logs show:
java.lang.IllegalArgumentException: Invalid column name_raw_contact_id

ps
logs show
error in
contactsutils_setdata (java line: 709)

 

[Erel]

It works fine:

 

[hzytsoft]

can u tell me u android ver？
pls

 

[hzytsoft]

maybe android 2.x ‘s datebase in not same as above ver
this is my contacts2.db

 

[Erel]

I tested it with Android 4.4. The related API is the same for Android 2.2+. However it possible that there is an issue with AddPhone.

 

[hzytsoft]

my phone is Android 2.37

 

[hzytsoft]

issue not with AddPhone
juest with SetData(Mime As String, Values As ContentValues, Id As Long, Update As Boolean)

Private Sub SetData(Mime As String, Values As ContentValues, Id As Long, Update As Boolean)
    If Update Then
        cr.Update(dataUri, Values, "mimetype = ? AND contact_id = ?", Array As String(Mime, Id))
    Else
        Dim crsr As Cursor = cr.Query(contactUri, Array As String("name_raw_contact_id"), _
            "_id = ?", Array As String(Id), "")
        If crsr.RowCount = 0 Then
            Log("Error getting raw_contact_id")
            crsr.Close
            Return
        End If
        crsr.Position = 0
        Values.PutString("raw_contact_id", crsr.GetString("name_raw_contact_id"))
        crsr.Close
        Values.PutString("mimetype", Mime)
        cr.Insert(dataUri, Values)
    End If
End Sub

 

[hzytsoft]

logs show:
java.lang.IllegalArgumentException: Invalid column name_raw_contact_id

 

[Erel]

I will check it.

 

[hzytsoft]

tks very much

 

[hzytsoft]

@Erel have any Progress？

 

[Erel]

Not yet. I will report if there are any findings.

 

[hzytsoft]

tks !

 

[Erel]

Try this updated sub:

Private Sub SetData(Mime As String, Values As ContentValues, id As Long, Update As Boolean)
   If Update Then
     cr.Update(dataUri, Values, "mimetype = ? AND contact_id = ?", Array As String(Mime, id))
   Else
     Try
       Dim crsr As Cursor = cr.Query(contactUri, Array As String("name_raw_contact_id"), _
         "_id = ?", Array As String(id), "")
       If crsr.RowCount = 0 Then
         Log("Error getting raw_contact_id")
         crsr.Close
         Return
       End If
       crsr.Position = 0
       Values.PutString("raw_contact_id", crsr.GetString("name_raw_contact_id"))
       crsr.Close
     Catch
       Values.PutString("raw_contact_id", id)
     End Try
     Values.PutString("mimetype", Mime)
     cr.Insert(dataUri, Values)
   End If
End Sub

 

[hzytsoft]

Try this updated sub:

Private Sub SetData(Mime As String, Values As ContentValues, id As Long, Update As Boolean)
   If Update Then
     cr.Update(dataUri, Values, "mimetype = ? AND contact_id = ?", Array As String(Mime, id))
   Else
     Try
       Dim crsr As Cursor = cr.Query(contactUri, Array As String("name_raw_contact_id"), _
         "_id = ?", Array As String(id), "")
       If crsr.RowCount = 0 Then
         Log("Error getting raw_contact_id")
         crsr.Close
         Return
       End If
       crsr.Position = 0
       Values.PutString("raw_contact_id", crsr.GetString("name_raw_contact_id"))
       crsr.Close
     Catch
       Values.PutString("raw_contact_id", id)
     End Try
     Values.PutString("mimetype", Mime)
     cr.Insert(dataUri, Values)
   End If
End Sub

it is work well
very tks

ps .
if this code also fit Android 2.X OR fit all ver?

 

[Erel]

This code is a fallback for older devices. It should work with Android 2.2+.

 

[hzytsoft]

so if use
ContactsUtils lib
must be check Android ver first
then use Different updated sub？

 

[Erel]

No. Compare the code to the previous one. You will immediately understand the changes. It will work for all devices.

 

[hzytsoft]

Perfect！
U means this code can fit all devices both Android 2.X OR Android 4.X or Android 3.X

 

[hzytsoft]

I really appreciate your help~~~
@Erel