Android Question ContactsUtils lib cannot add pnone

hzytsoft · Dec 10, 2013

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 · Dec 11, 2013

It works fine:

hzytsoft · Dec 11, 2013

can u tell me u android ver？
pls

hzytsoft · Dec 11, 2013

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

Erel · Dec 11, 2013

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 · Dec 11, 2013

my phone is Android 2.37

hzytsoft · Dec 11, 2013

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

B4X:

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 · Dec 11, 2013

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

Erel · Dec 11, 2013

I will check it.

hzytsoft · Dec 11, 2013

tks very much

hzytsoft · Dec 12, 2013

@Erel have any Progress？

Erel · Dec 12, 2013

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

hzytsoft · Dec 12, 2013

tks !

Erel · Dec 12, 2013

Try this updated sub:

B4X:

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 · Dec 12, 2013

Erel said:

Try this updated sub:

B4X:

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 · Dec 12, 2013

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

hzytsoft · Dec 12, 2013

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

Erel · Dec 12, 2013

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

hzytsoft · Dec 12, 2013

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

hzytsoft · Dec 12, 2013

I really appreciate your help~~~
@Erel

Android Question ContactsUtils lib cannot add pnone

Member

Attachments

B4X founder

Member

Member

Attachments

B4X founder

Member

Member

Member

B4X founder

Member

Member

B4X founder

Member

B4X founder

Member

B4X founder

Member

B4X founder

Member

Member

Similar Threads

Privacy & Transparency

Privacy & Transparency