When executing myda.update(myds,"cert").  I get the message

"The field 'Cert.DateofInspection' cannot contain a Null value because the
Required property for this field is set to True. Enter a value in this
field."

myda has a commandbuilder assigned (see the generated insert command,
below).  This makes no sense whatever to me, unless commandBuilder is
broken.

The table "cert" contains 1 row, and the offending column has the value:

? r.Item("DateOfInspection")
  #5/14/2005# {Date}
  [Date]: #5/14/2005#

Generated command:

INSERT INTO Cert( JobNumber , PoolNumber , CertType , FieldOfficeName ,
ClientID , DateofInspection , InTF , OutTF , Submit , OriginalInspection ,
Reinspection , Hopper , Truck , RailCar , MethodofSampling ,
IdentificationofGrain , KindOfGrainCodeName , Class , Grade , SpecialGrade ,
GradeandKind , PanTicketGrade , DKG , TestWeightperBushel , Moisture ,
HeatDamageTotal , Damage , ForeignMaterial , ShrunkenAndBroken ,
TotalDefects , ContrastingClasses , WheatofOtherClasses , BCFM , BKandFM ,
Splits , DHV , Protein , Odor , OtherGrain , WildOats , Sound , Broken ,
Thin , FN , Aflatoxin , Vomatoxin , Germination , Remarks , TopFeet ,
BottomNotSampled , Inspector , PanTicketNum , FMDetails , DamageDetails ,
DatePrinted , Plump , CompleteRemarks , Stones , Filth , FMOW , Dehulled ,
Summary , SOOColor , SMT , Sorts , IDKCount , ClubCount , Superseded ,
Weigher , Weight , InputDate , UnloadDate ) VALUES ( ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? )

Why?  What can I be doing wrong?  Is CommandBuilder broken?

Jeremy

Hi,

        I dont see any errors in the command builders insert command.  Maybe
you could post some code on how you add the record.

Ken
------------------------
When executing myda.update(myds,"cert").  I get the message

"The field 'Cert.DateofInspection' cannot contain a Null value because the
Required property for this field is set to True. Enter a value in this
field."

myda has a commandbuilder assigned (see the generated insert command,
below).  This makes no sense whatever to me, unless commandBuilder is
broken.

The table "cert" contains 1 row, and the offending column has the value:

? r.Item("DateOfInspection")
  #5/14/2005# {Date}
  [Date]: #5/14/2005#

Generated command:

INSERT INTO Cert( JobNumber , PoolNumber , CertType , FieldOfficeName ,
ClientID , DateofInspection , InTF , OutTF , Submit , OriginalInspection ,
Reinspection , Hopper , Truck , RailCar , MethodofSampling ,
IdentificationofGrain , KindOfGrainCodeName , Class , Grade , SpecialGrade ,
GradeandKind , PanTicketGrade , DKG , TestWeightperBushel , Moisture ,
HeatDamageTotal , Damage , ForeignMaterial , ShrunkenAndBroken ,
TotalDefects , ContrastingClasses , WheatofOtherClasses , BCFM , BKandFM ,
Splits , DHV , Protein , Odor , OtherGrain , WildOats , Sound , Broken ,
Thin , FN , Aflatoxin , Vomatoxin , Germination , Remarks , TopFeet ,
BottomNotSampled , Inspector , PanTicketNum , FMDetails , DamageDetails ,
DatePrinted , Plump , CompleteRemarks , Stones , Filth , FMOW , Dehulled ,
Summary , SOOColor , SMT , Sorts , IDKCount , ClubCount , Superseded ,
Weigher , Weight , InputDate , UnloadDate ) VALUES ( ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? )

Why?  What can I be doing wrong?  Is CommandBuilder broken?

Jeremy

DLL Function Export
Simple mail application
What is your weightage of the 3 characteristics of Object-Oriented Programming....
End Processes
EndCurrentEdit Tips?
Converting an array from integer to string
StreamReader.Seek(0, Begin)
Threading Issue
Looking for a better way to compress images.
Disable the popup security message from Outlook2003.