Reserved Words
- From: restucci@xxxxxxxxx
- Date: 13 Jun 2006 06:31:43 -0700
I am attempting to update/insert to a Microsoft Access Database. I have
a database column that is unfortunately using a the reserved word
'output'. Changing this name isn't a very viable option (at least not
now). My problem is that I cannot get the database to update using .net
because it gives me the following error: "The field
'tblTimesheetEntries.Output' cannot contain a Null value because the
Required property for this field is set to True. Enter a value in this
field." It's all bound correctly on the page and I'm pretty sure it
is a problem with using the reserved word 'output'. The column name
output is bracketed ([output]) in the update and insert statements. If
anyone knows of a workaround for this it would be greatly appreciated.
Jimmy
.
- Follow-Ups:
- Re: Reserved Words
- From: restucci@xxxxxxxxx
- Re: Reserved Words
- From: Marina Levit [MVP]
- Re: Reserved Words
- Prev by Date: Re: DataAdapetr Update
- Next by Date: Re: Typed DataSet Navigation (Multiple Tables)
- Previous by thread: Re: DataAdapetr Update
- Next by thread: Re: Reserved Words
- Index(es):