android.widget.EditEext@44fcdeo ???

[rleiman]

Hi Everyone,

android.widget.EditEext@44fcdeo

Huh? What is it and how do I get rid of it?

I get this in one my EditText boxes if I insert the data into a database table with all EditText boxes filled in.

This is the table insert statement I'm using:

         SQL.ExecNonQuery2("INSERT INTO PeopleToVisit " & _ 
                       "(Id, FirstName, LastName, AddressHouseNumber, AddressStreetName, City, State, Zip, DateOfLastVisit, " & _
                       "PrimaryPhone, SecondaryPhone, Email, LastVisitNote) " & _
                       "VALUES " & _
                       "(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", _
                      Array As Object(Null, _
                                   EditTextFirstName.Text, _
                                  EditTextLastName.Text, _
                                      EditTextAddressHouseNumber.Text, _
                                     EditTextAddressStreetName.Text, _
                                     EditTextCity.Text, _
                                     EditTextState.Text, _
                                     EditTextZip.Text, _
                                     EditTextDateOfLastVisit.Text, _
                                     EditTextPrimaryPhone.Text, _
                                     EditTextSecondaryPhone.Text, _
                                     EditTextEmail.Text, _
                                  EditTextLastVisitNote _
                                  ))

This is the statement I use to view the data:

     oRecordSet = SQL.ExecQuery( _
        "SELECT Id, FirstName, LastName, AddressHouseNumber, AddressStreetName, City, State, Zip, DateOfLastVisit, " & _
              "PrimaryPhone, SecondaryPhone, Email, LastVisitNote " & _
          "FROM PeopleToVisit " & _
         "WHERE id = " & intCurrentId)

   If oRecordSet.RowCount > 0 Then
      oRecordSet.Position = 0

      EditTextFirstName.Text = oRecordSet.GetString("FirstName")
      EditTextLastName.Text = oRecordSet.GetString("LastName")
      EditTextAddressHouseNumber.Text = oRecordSet.GetString("AddressHouseNumber")
      EditTextAddressStreetName.Text = oRecordSet.GetString("AddressStreetName")
      EditTextCity.Text = oRecordSet.GetString("City")
      EditTextState.Text = oRecordSet.GetString("State")
      EditTextZip.Text = oRecordSet.GetString("Zip")
      EditTextDateOfLastVisit.Text = oRecordSet.GetString("DateOfLastVisit")
      EditTextPrimaryPhone.Text = oRecordSet.GetString("PrimaryPhone")
      EditTextSecondaryPhone.Text = oRecordSet.GetString("SecondaryPhone")
      EditTextEmail.Text = oRecordSet.GetString("Email")
      EditTextLastVisitNote.Text = oRecordSet.GetString("LastVisitNote")
    End If

Did I do something wrong with my query statements?

If I go back in and modify the data in the EditText box and save it as an Update, everything is normal with out that strange value in the EditText box.

Thanks.

 

[stevel05]

It is the edit text object pointer, Your insert statement has EditTextLastVisitNote instead of EditTextLastVisitNote.Text

 

[rleiman]

Hi Steve,

Thanks for such a speedy reply and good catch on the missing .Text word. :sign0060:

 

[stevel05]

No Problem, there are many things you can stare at for hours after convincing yourself that it's all OK, and still not see. This is definitely one of those.

 

[rleiman]

Very true indeed. I helped many people with that sort of thing when I used to have a programming job. I think it's something like "Writer's block". That's when co-workers really come in handy.

Hi Steve,

Thanks for such a speedy reply and good catch on the missing .Text word. :sign0060: