-
Error 80040E14
When I try to update a record, I get the following error after clicking the 'update current record' button.
Error # = 80040E14
Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in date in query expression '# = 1'.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = 37000
NativeError = -3100
Here's the relevant asp file...
MyDb.DbMode="dual"
MyDb.DbGridInc = "5"
MyDb.DbSQL = "Select * FROM job_info_by_division" MyDb.DbNavigationItem="filter,top,prev,next,bo ttom,download,color,reload,update, add"
MyDb.DbNavigationIcon="std"
Mydb.dbEditDropFlds = "Jobtype,,,ENGINEERING/MOD/OTHER"
Mydb.dbEditFlds = "JobType, Tour,last, first, Mail Code, Division Name, Contact, Job Info"
Mydb.dbEditParams = "TableName=job_info_by_division,BookMarkFlds=0 ,TableTag=Border=2,InputSize=10x80"
MyDb.dbFilterParams = "TableTag=Border=2,, ApplyButtonText=Apply Filter, DropButtonText=None,, "
MyDb.DbFilterDropFlds = "JobType,,job_info_by_division,JobType,,,NoBla nk,,DISTINCT"
MyDb.DbFilterFlds="JobType,style=simple"
MyDb.dbGridDisplayFlds="JobType,Tour,Last,Firs t, Mail Code, Division Name, Contact"
MyDb.dbFormDisplayFlds="-1"
MyDb.DbFormMemo="10x80,Job Info"
MyDb.aspDBpro
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
|
|