-
error in UPDATE statement. during edit
Error # = 80040E14
Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = 37000
NativeError = -3503
I get the above when trying to edit/update and existing record. I get all the fields listed and can enter the data, but when I press the 'Update current record button I always get this error.
My ASP script follows:
<%
Set MyDb = Server.CreateObject("AspDB.Pro"
MyDb.dbUnit = 10
MyDb.DBColor = "black,yellow,gray,white,,,,,yellow"
MyDb.dbImageDir="../images/"
MyDb.dbGridTableTag = "border=1 cellspacing=3 cellpadding=3 align=center"
MyDb.DbDSN="DSN=enchantedsw"
MyDb.DbStatusbar="False"
MyDb.DbMode = "Both"
MyDb.dbSQL = "Select * from carvings"
MyDb.DbMemoTextSize=-1
MyDb.dbNavigation="both"
MyDb.dbNavigationItem="Next, Prev, Gridrow, Filter, add, update, edit, delete"
MyDb.dbNavigationIcon="std"
MyDb.dbEditParams="Tablename=carvings,Bookmark Flds=ID"
MyDb.dbEditFlds="1,2,3,4,5,6,7,8,9,10,11,12 4;
MyDb.aspDBPro
%>
Everything else I try to do seems to work fine.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|