Problems with Edit/Update/Delete

[Chris]

As soon as I click on the appropriate button (either 'update record, delete current record&#39 I get the error below... Any ideas?

Error # = 80040E14
Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in date in query expression '# = 14'.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = 37000
NativeError = -3100

Here's the code I have:

MyDb.DbMode="dual"
MyDb.DbGridInc = "5"
MyDb.DbSQL = "Select * FROM job_info_by_division"
' MyDb.dbDBType="SQL"

MyDb.DbNavigationItem="filter,top,prev,next,bo ttom,download,color,reload, add,delete"
MyDb.DbNavigationIcon="std"

Mydb.dbEditDropFlds = "Jobtype,,,ENGINEERING/MOD/OTHER"
Mydb.dbEditFlds = "JobType, Tour,last, first, Mail Code, Division, Contact, Job Info"
Mydb.dbEditParams = "TableName=job_info_by_division,BookMarkFlds=0 ,TableTag=Border=2,InputSize=10x80,RecordScope=sin gle,UpdateText=Update"

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, Contact"
MyDb.dbFormDisplayFlds="-1"

MyDb.DbFormMemo="10x80,Job Info"

MyDb.aspDBpro

[Frank Kwong]

Which one is your "daet" field ? Turn on your debug option and see the Edit querystring and post it.

FK
------------
Chris at 5/15/00 2:43:15 PM

As soon as I click on the appropriate button (either 'update record, delete current record&#39 I get the error below... Any ideas?

Error # = 80040E14
Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in date in query expression '# = 14'.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = 37000
NativeError = -3100

Here's the code I have:

MyDb.DbMode="dual"
MyDb.DbGridInc = "5"
MyDb.DbSQL = "Select * FROM job_info_by_division"
' MyDb.dbDBType="SQL"

MyDb.DbNavigationItem="filter,top,prev,next,bo ttom,download,color,reload, add,delete"
MyDb.DbNavigationIcon="std"

Mydb.dbEditDropFlds = "Jobtype,,,ENGINEERING/MOD/OTHER"
Mydb.dbEditFlds = "JobType, Tour,last, first, Mail Code, Division, Contact, Job Info"
Mydb.dbEditParams = "TableName=job_info_by_division,BookMarkFlds=0 ,TableTag=Border=2,InputSize=10x80,RecordScope=sin gle,UpdateText=Update"

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, Contact"
MyDb.dbFormDisplayFlds="-1"

MyDb.DbFormMemo="10x80,Job Info"

MyDb.aspDBpro