Results 1 to 8 of 8
  1. #1
    Join Date
    May 2012
    Posts
    5

    Unanswered: Record Completion Issue

    Working with the Head First eBook. Through Visual Studio, I have completed the tables for a contacts database. Using MS SQL Compact 2010 3.5 SP2.https://skydrive.live.com/redir?resi...F3F75A51A!1051 Regrettably, Last Call, a datetime entry is not accepted. A two second video and some images are uploaded to Microsoft Sky Drive. Followed the eBook lesson and the table appears to be identical. Guidance sought

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Eh?

    How about a specific question?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Dec 2010
    Location
    Manchester
    Posts
    24
    Sorry you dont seem to have explained the problem too well, is it the date time column thats causing trouble and if so is it that your code is not updating the problem, if so you need to use SQL to convert the data to the relevent type first,

    Code:
    LastCall = CONVERT(datetime,'" & FIELDNAMEHERE & "',103)
    Last edited by Batou; 05-23-12 at 11:27.

  4. #4
    Join Date
    May 2012
    Posts
    5

    DateTime Column Problem

    Greetings:

    Much thanks for the timely reply. My apologies as I write as one who has just started to learn SQL. My specific question is: What causes the problem that leads to the error:
    No row was updated
    The data in row 1 was not committed
    error source mscorlib
    error message the path is not of a legal form
    correct the errors and press escape or cancel


    Additionally, what must one do to correct the problem. Since I am following a book I did not expect an error.

  5. #5
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Those are not SQL Server error messages. They probably originate from your application code.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  6. #6
    Join Date
    Aug 2004
    Location
    Dallas, Texas
    Posts
    831
    Quote Originally Posted by blindman View Post
    Those are not SQL Server error messages. They probably originate from your application code.
    Those were probably planted in the sysmessage table to confuse the apps developer.

  7. #7
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    What were you trying to run that will cause the error(s) ?

    The answer is NOT "the example in the book".

    For someone to be able to help, you need to provide more details.

  8. #8
    Join Date
    May 2012
    Posts
    5

    DateTime Column Problem

    Much thanks for your reply. Please know that the error message no longer appears without intervention. In advancing through the lesson I now find a different issue. The new topic is Adding database driven controls. The exercise requires that the database be accessed through Visual Studio, the Windows database form be dragged onto the IDE, and the database be dragged onto the Form. Not clear on how to get the form onto the IDE... tried to drag it with no success.

    Your support is appreciated. I await your reply
    Attached Thumbnails Attached Thumbnails Database Driven Controls.jpg  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •