May 19, 2012 at 12:36 pm
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
May 19, 2012 at 3:11 pm
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]
May 19, 2012 at 4:59 pm
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
May 20, 2012 at 5:01 am
Try to enter it in ANSI pattern... e.g. 2012-05-20 16:30:23.623
May 20, 2012 at 5:07 am
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’.
May 20, 2012 at 3:16 pm
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply