Results 1 to 7 of 7

Thread: Can't update ID field?

  1. #1
    Mark Guest

    Can't update ID field?


    I have just started playing with the Pro-Eval version of aspdb and it looks like it will fit my needs nicely. However, I am trying to get the edit record and add record function working, but I get the following error when I click the Update Record button:






    Error # = 80040E14
    Description = [Microsoft][ODBC Microsoft Access 97 Driver] Can't update 'ID'; field not updatable.
    Source = Microsoft OLE DB Provider for ODBC Drivers
    SQL State = 23000
    NativeError = -1048

    I added the Hide ID field line to my code, but it still is having problems. So, what do I do to correct it?

  2. #2
    Mark Guest

    Can't update ID field? (reply)

    Mark,
    First of all, I have to ask you ...
    Does our diagnostic program (asp-test-pro.asp) run OK?

    If asp-test-pro.asp runs OK, but your program does not, then I would
    say there is an error in your program and I must see your source code
    to determine what you have done wrong.

    So, if you're still having problems, please post you entire source code
    so we can review it.

    P.S. You said you did this: "Hide ID". Using what ASP-db property?
    dbGridHideFlds? Not the right place to "hide" it.
    You must use dbEditFlds and do not include include ID on the line.
    For example, use: mydb.dbEditFlds = "Name, Address, Phone"

    Thanks,
    Mark.



    ------------
    Mark at 12/12/99 10:15:48 AM


    I have just started playing with the Pro-Eval version of aspdb and it looks like it will fit my needs nicely. However, I am trying to get the edit record and add record function working, but I get the following error when I click the Update Record button:






    Error # = 80040E14
    Description = [Microsoft][ODBC Microsoft Access 97 Driver] Can't update 'ID'; field not updatable.
    Source = Microsoft OLE DB Provider for ODBC Drivers
    SQL State = 23000
    NativeError = -1048

    I added the Hide ID field line to my code, but it still is having problems. So, what do I do to correct it?

  3. #3
    Mark T Guest

    Can't update ID field? (reply)

    The Update record field works ok in the asp-test-pro.asp file, but the Add New Record option does not. It generates the following error:



    aspDB error '800a0005'

    Invalid procedure call or argument

    /aspdb/asp-test-pro.asp, line 35


    ------------
    Mark at 12/12/99 8:23:45 PM

    Mark,
    First of all, I have to ask you ...
    Does our diagnostic program (asp-test-pro.asp) run OK?

    If asp-test-pro.asp runs OK, but your program does not, then I would
    say there is an error in your program and I must see your source code
    to determine what you have done wrong.

    So, if you're still having problems, please post you entire source code
    so we can review it.

    P.S. You said you did this: "Hide ID". Using what ASP-db property?
    dbGridHideFlds? Not the right place to "hide" it.
    You must use dbEditFlds and do not include include ID on the line.
    For example, use: mydb.dbEditFlds = "Name, Address, Phone"

    Thanks,
    Mark.



    ------------
    Mark at 12/12/99 10:15:48 AM


    I have just started playing with the Pro-Eval version of aspdb and it looks like it will fit my needs nicely. However, I am trying to get the edit record and add record function working, but I get the following error when I click the Update Record button:






    Error # = 80040E14
    Description = [Microsoft][ODBC Microsoft Access 97 Driver] Can't update 'ID'; field not updatable.
    Source = Microsoft OLE DB Provider for ODBC Drivers
    SQL State = 23000
    NativeError = -1048

    I added the Hide ID field line to my code, but it still is having problems. So, what do I do to correct it?

  4. #4
    Frank Guest

    Can't update ID field? (reply)

    Please note that you cannot update a bookmark field. Just exclude that from your edit fields and try again.


    Fk


    ------------
    Mark at 12/12/99 10:15:48 AM


    I have just started playing with the Pro-Eval version of aspdb and it looks like it will fit my needs nicely. However, I am trying to get the edit record and add record function working, but I get the following error when I click the Update Record button:






    Error # = 80040E14
    Description = [Microsoft][ODBC Microsoft Access 97 Driver] Can't update 'ID'; field not updatable.
    Source = Microsoft OLE DB Provider for ODBC Drivers
    SQL State = 23000
    NativeError = -1048

    I added the Hide ID field line to my code, but it still is having problems. So, what do I do to correct it?

  5. #5
    Mark T Guest

    Can't update ID field? (reply)


    P.S. You said you did this: "Hide ID". Using what ASP-db property?
    dbGridHideFlds? Not the right place to "hide" it.
    You must use dbEditFlds and do not include include ID on the line.
    For example, use: mydb.dbEditFlds = "Name, Address, Phone"

    That worked to allow me to update an existing record. Now how do I get it to let me add records? I'm still getting:

    aspDB error '80010012'

    Automation error

    /eps/rawedit1.asp, line 31 error 'ASP 0194'

    OnEndPage Failed

    /eps/rawedit1.asp

    An error occurred in the OnEndPage method of an external object.

    ------------
    Mark at 12/12/99 8:23:45 PM

    Mark,
    First of all, I have to ask you ...
    Does our diagnostic program (asp-test-pro.asp) run OK?

    If asp-test-pro.asp runs OK, but your program does not, then I would
    say there is an error in your program and I must see your source code
    to determine what you have done wrong.

    So, if you're still having problems, please post you entire source code
    so we can review it.

    P.S. You said you did this: "Hide ID". Using what ASP-db property?
    dbGridHideFlds? Not the right place to "hide" it.
    You must use dbEditFlds and do not include include ID on the line.
    For example, use: mydb.dbEditFlds = "Name, Address, Phone"

    Thanks,
    Mark.



    ------------
    Mark at 12/12/99 10:15:48 AM


    I have just started playing with the Pro-Eval version of aspdb and it looks like it will fit my needs nicely. However, I am trying to get the edit record and add record function working, but I get the following error when I click the Update Record button:






    Error # = 80040E14
    Description = [Microsoft][ODBC Microsoft Access 97 Driver] Can't update 'ID'; field not updatable.
    Source = Microsoft OLE DB Provider for ODBC Drivers
    SQL State = 23000
    NativeError = -1048

    I added the Hide ID field line to my code, but it still is having problems. So, what do I do to correct it?

  6. #6
    Mark H. Guest

    Can't update ID field? (reply)

    Mark,

    If asp-test-pro can only do some of: adds, updates, and deletes, then it
    sounds like you are either using PWS 3.0 (you MUST use 4.0) or you have
    old ADO drivers. You can get the links to Microsoft's update sites from our
    website at: http://www.aspdb.com/usefullinks.asp
    You MUST use PWS 4.0 and ADO 1.5 minimum (we recommend ADO/MDAC 2.1)

    That should help.

    Let's get asp-test-pro to work perfectly before we try to debug YOUR code.

    Mark H.




    ------------
    Mark T at 12/12/99 10:22:48 PM


    P.S. You said you did this: "Hide ID". Using what ASP-db property?
    dbGridHideFlds? Not the right place to "hide" it.
    You must use dbEditFlds and do not include include ID on the line.
    For example, use: mydb.dbEditFlds = "Name, Address, Phone"

    That worked to allow me to update an existing record. Now how do I get it to let me add records? I'm still getting:

    aspDB error '80010012'

    Automation error

    /eps/rawedit1.asp, line 31 error 'ASP 0194'

    OnEndPage Failed

    /eps/rawedit1.asp

    An error occurred in the OnEndPage method of an external object.

    ------------
    Mark at 12/12/99 8:23:45 PM

    Mark,
    First of all, I have to ask you ...
    Does our diagnostic program (asp-test-pro.asp) run OK?

    If asp-test-pro.asp runs OK, but your program does not, then I would
    say there is an error in your program and I must see your source code
    to determine what you have done wrong.

    So, if you're still having problems, please post you entire source code
    so we can review it.

    P.S. You said you did this: "Hide ID". Using what ASP-db property?
    dbGridHideFlds? Not the right place to "hide" it.
    You must use dbEditFlds and do not include include ID on the line.
    For example, use: mydb.dbEditFlds = "Name, Address, Phone"

    Thanks,
    Mark.



    ------------
    Mark at 12/12/99 10:15:48 AM


    I have just started playing with the Pro-Eval version of aspdb and it looks like it will fit my needs nicely. However, I am trying to get the edit record and add record function working, but I get the following error when I click the Update Record button:



    Error # = 80040E14
    Description = [Microsoft][ODBC Microsoft Access 97 Driver] Can't update 'ID'; field not updatable.
    Source = Microsoft OLE DB Provider for ODBC Drivers
    SQL State = 23000
    NativeError = -1048

    I added the Hide ID field line to my code, but it still is having problems. So, what do I do to correct it?

  7. #7
    Mark T Guest

    Can't update ID field? (reply)


    Thanks Mark! That appears to have fixed it. And it works MUCH faster to boot! I definitely like this newer version of PWS. Apparently I had PWS V1.0 from the VI install I did. Definitely slicker now :>
    Thanks for the help with this little problem. Now I can get to work building a REAL interface, etc.

    ------------
    Mark H. at 12/12/99 10:31:52 PM

    Mark,

    If asp-test-pro can only do some of: adds, updates, and deletes, then it
    sounds like you are either using PWS 3.0 (you MUST use 4.0) or you have
    old ADO drivers. You can get the links to Microsoft's update sites from our
    website at: http://www.aspdb.com/usefullinks.asp
    You MUST use PWS 4.0 and ADO 1.5 minimum (we recommend ADO/MDAC 2.1)

    That should help.

    Let's get asp-test-pro to work perfectly before we try to debug YOUR code.

    Mark H.

    ------------
    Mark T at 12/12/99 10:22:48 PM


Posting Permissions

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