Table Data Insertion

Table Data Insertion Single Column rejects data

#1 PhilPense

Active Member

Group: Members
Posts: 11
Joined: 16-May 12
Gender:Male
Location:Washington, DC
Interests:Travel, Information Technology

Posted 18 May 2012 - 01:49 PM

Able to enter data in the recently created table. Everything except row1 column 6... invalid value. Don't know how to address this. Looking for troubleshooting guidance

Attached thumbnail(s)

#2 Sikta_26785

Active Member

Group: Members
Posts: 67
Joined: 18-May 11

Posted 22 May 2012 - 07:25 PM

Boolean data type means that 'true' or 'false' are valid values. YES is not a valid data type for this field. (Note: it could be '0' or '1' in this entry format.)

#3 PhilPense

Active Member

Group: Members
Posts: 11
Joined: 16-May 12
Gender:Male
Location:Washington, DC
Interests:Travel, Information Technology

Posted 24 May 2012 - 01:18 PM

Sikta_26785, on 22 May 2012 - 07:25 PM, said:

Boolean data type means that 'true' or 'false' are valid values. YES is not a valid data type for this field. (Note: it could be '0' or '1' in this entry format.)

#4 PhilPense

Active Member

Group: Members
Posts: 11
Joined: 16-May 12
Gender:Male
Location:Washington, DC
Interests:Travel, Information Technology

Posted 24 May 2012 - 02:14 PM

Sikta_26785, on 22 May 2012 - 07:25 PM, said:

Boolean data type means that 'true' or 'false' are valid values. YES is not a valid data type for this field. (Note: it could be '0' or '1' in this entry format.)

Greetings Sikta:

As ususal, you have been helpful with my studies. I recognized the issue just after posting and so I solved this one myself. I have moved on and find another issue. The database has been populated and now I want to drag the table onto the form. The text is not specific on this and I have uploaded an image of my circumstance. My People table has no arrow next to it. The issue is how to get the Objectville form onto the IDE then drag 'people' onto it. Much thanks for your continued support.

Attached thumbnail(s)

#5 Sikta_26785

Active Member

Group: Members
Posts: 67
Joined: 18-May 11

Posted 25 May 2012 - 09:52 PM

These are the steps to make it look like it does in the book.

1) Right click Form1.cs in the solutions explorer and choose to "View Designer"
2) Select "People" in the Data Sources explorer
3) Click the dropdown arrow next to "People" and choose "Details" (NOTE: There are many different control types you can select here. Play around with them afterwards.)
4) Click and drag "People" onto the form.

You should now have something that looks like what is in the book. You can move the individual controls around and place the Objectville logo to complete it.