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:
This is the statement I use to view the data:
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.
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:
B4X:
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:
B4X:
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 IfDid 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.
Last edited: