SQL Table column issue

Question

Post reply

SQL Table column issue

philpense

Old Hand

Points: 350
More actions
May 19, 2012 at 12:36 pm

#256148

Following guidance of the "Head First" ebook. Using Visual Studio 2008 and creating a 'contacts' database within it. Completed tables using SQL Compact 3.5 and partially completed one record. The datetime column would not allow an entry and error message was as follows:
Invalid value for cell (row 1, column 6) The changed value in this cell was not recognized as a valid .NET Framework Data Type: Boolean Error message: String was not recognized as a valid Boolean. Type a value appropriate for the datatype or press ESC to cancel. Table created looks identical to what is shown in the eBook exercise

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

RBarryYoung SSC Guru Points: 143329 More actions · Answer 1

Which column is it and what exactly are you trying to enter?

(I ask because it doesn't look like a date column/value that you are trying to enter).

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

philpense Old Hand Points: 350 More actions · Answer 2

Much thanks for your timely reply. The tables include the last time of client interaction which is a datetime entity. The column appears but will not allow anything to be entered. I believe I've followed the eBook guidance precisely but an experienced eye is welcome. A three second video is uploaded toL I await your reply

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 3

Try to enter it in ANSI pattern... e.g. 2012-05-20 16:30:23.623

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 4

Oops… Just noticed the error message “Boolean Data Type mismatch’. It’s certainly on column ‘Client’ where you entered ‘Yes’. Please enter true/false as valid values for Boolean data type in ‘Edit rows mode’.

philpense Old Hand Points: 350 More actions · Answer 5

Was able to change value to TRUE and move on to DateTime. another error presents itself as shown in the image uploaded to:

Entered the date and the time entered itself. Your continued guidance would be appreciated.

SQL Table column issue

Cookies on SQLServerCentral