If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
UPDATE
Using the database Results wizard in Frontpage I have set up a database
editor page but get a database connection error when I verify the criteria: Server error: Unable to retrieve schema information from the query: UPDATE Results SET Sector = '1' , Company = '2' , Contact = '3' , Website = '4' , Email = '5' , Telephone = '6' , Address = '7' , Position = '8' , Area = '9' , Salary = '10' , Per = '11' , Description = '12' , Remote_computer_name = '13' , Timestamp = '14' , Ref = '15' , subject = '16' , User_name = '17' , Browser_type = '18' WHERE (ID = 19) The following error message comes from the database driver software; it may appear in a different language depending on how the driver is configured. ------------------------------------------------------- [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. Source: Microsoft OLE DB Provider for ODBC Drivers Number: -2147217900 (0x80040e14) This is the SQL statement: UPDATE Results SET Sector = '::Sector::' , Company = '::Company::' , Contact = '::Contact::' , Website = '::Website::' , Email = '::Email::' , Telephone = '::Telephone::' , Address = '::Address::' , Position = '::Position::' , Area = '::Area::' , Salary = '::Salary::' , Per = '::Per::' , Description = ':escription::' , Remote_computer_name = '::Remote_computer_name::' , Timestamp = '::Timestamp::' , Ref = '::Ref::' , subject = '::subject::' , User_name = '::User_name::' , Browser_type = '::Browser_type::' WHERE (ID = ::ID: I would appreciate your help! Anna Mac |
#2
|
|||
|
|||
UPDATE
Are all of the fields Text fields (with the exception of ID)? That's what
your UPDATE statement is assuming... If the fields are numeric, remove the single quotes. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "annaMac" wrote in message ... Using the database Results wizard in Frontpage I have set up a database editor page but get a database connection error when I verify the criteria: Server error: Unable to retrieve schema information from the query: UPDATE Results SET Sector = '1' , Company = '2' , Contact = '3' , Website = '4' , Email = '5' , Telephone = '6' , Address = '7' , Position = '8' , Area = '9' , Salary = '10' , Per = '11' , Description = '12' , Remote_computer_name = '13' , Timestamp = '14' , Ref = '15' , subject = '16' , User_name = '17' , Browser_type = '18' WHERE (ID = 19) The following error message comes from the database driver software; it may appear in a different language depending on how the driver is configured. ------------------------------------------------------- [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. Source: Microsoft OLE DB Provider for ODBC Drivers Number: -2147217900 (0x80040e14) This is the SQL statement: UPDATE Results SET Sector = '::Sector::' , Company = '::Company::' , Contact = '::Contact::' , Website = '::Website::' , Email = '::Email::' , Telephone = '::Telephone::' , Address = '::Address::' , Position = '::Position::' , Area = '::Area::' , Salary = '::Salary::' , Per = '::Per::' , Description = ':escription::' , Remote_computer_name = '::Remote_computer_name::' , Timestamp = '::Timestamp::' , Ref = '::Ref::' , subject = '::subject::' , User_name = '::User_name::' , Browser_type = '::Browser_type::' WHERE (ID = ::ID: I would appreciate your help! Anna Mac |
#3
|
|||
|
|||
UPDATE
Hi Doug, Yes that's correct. Actually I have done some more research - it
seems that Timestamp is a reserved word and had to be put in square brackets, plus any fields that may be empty had to be designated as yes for zero length. Now it works. Anna "annaMac" wrote: Using the database Results wizard in Frontpage I have set up a database editor page but get a database connection error when I verify the criteria: Server error: Unable to retrieve schema information from the query: UPDATE Results SET Sector = '1' , Company = '2' , Contact = '3' , Website = '4' , Email = '5' , Telephone = '6' , Address = '7' , Position = '8' , Area = '9' , Salary = '10' , Per = '11' , Description = '12' , Remote_computer_name = '13' , Timestamp = '14' , Ref = '15' , subject = '16' , User_name = '17' , Browser_type = '18' WHERE (ID = 19) The following error message comes from the database driver software; it may appear in a different language depending on how the driver is configured. ------------------------------------------------------- [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. Source: Microsoft OLE DB Provider for ODBC Drivers Number: -2147217900 (0x80040e14) This is the SQL statement: UPDATE Results SET Sector = '::Sector::' , Company = '::Company::' , Contact = '::Contact::' , Website = '::Website::' , Email = '::Email::' , Telephone = '::Telephone::' , Address = '::Address::' , Position = '::Position::' , Area = '::Area::' , Salary = '::Salary::' , Per = '::Per::' , Description = ':escription::' , Remote_computer_name = '::Remote_computer_name::' , Timestamp = '::Timestamp::' , Ref = '::Ref::' , subject = '::subject::' , User_name = '::User_name::' , Browser_type = '::Browser_type::' WHERE (ID = ::ID: I would appreciate your help! Anna Mac |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to update these figures? | Yorkie118 | Running & Setting Up Queries | 11 | October 22nd, 2005 05:56 PM |
Update problem | Roy Smith | New Users | 2 | October 12th, 2005 10:47 PM |
Failed update for Outlook 2003 Junk Email Filter | RLMuller | General Discussions | 2 | September 5th, 2005 11:08 AM |
Update query giving blank results - Access 2003 | Ann Scharpf | Running & Setting Up Queries | 2 | September 3rd, 2005 10:21 AM |
Auto Update Problem - OE Now Not Deleting Some Messages | Kirk Kridner | Outlook Express | 0 | July 16th, 2004 09:31 PM |