#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2001
    Posts
    92
    Rep Power
    14

    Operation must use an updateable query


    can anybody tell me wat this error means??

    Code:
    Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query., SQL state S1000 in SQLExecDirect in c:\inetpub\wwwroot\amega\shared.inc on line 8
  2. #2
  3. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2002
    Location
    NJ, USA
    Posts
    91
    Rep Power
    13
    What is line 8?
    - Walt

    Will code for food.
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2001
    Posts
    92
    Rep Power
    14
    line 8 :

    PHP Code:
    odbc_errormsg(); 
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2001
    Location
    High above the mucky-muck (Columbus, OH)
    Posts
    266
    Rep Power
    14
    It almost sounds like you're trying to update a view which is not updateable?

    What is your SQL and table structure for the query?
  8. #5
  9. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2001
    Posts
    92
    Rep Power
    14
    well, when i use windows98, access 2000, php4.0.6 to do the testing, everything works fine.

    but when i use windows xpprofessional, access xp, php4.1.2, then i got this error and record cannot save to the table.

    i tried to recreate the database in accessxp, but i still got this error.

IMN logo majestic logo threadwatch logo seochat tools logo