i am having a problem with this piece of code,
it is linking do a foxpro database but in this particular
table there are about 18 fields. i only want to update these
particular ones but i am getting an error saying that
a field cannot be blank. the last line is one work around but
i do not want to have 10 or so lines like the last every time
i want to add to the table
Cheers and thanks in advance
~M
P.S. it connects alright it is just the blank entries in the table
the exact error message is
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Visual FoxPro Driver]Field PER_DDATE does not accept null values
permitRS.Open "permit", objConn, , adLockOptimistic, adCmdTable
permitRS.AddNew
permitRS.Fields("per_num") = newpermitnum
permitRS.Fields("per_eng") = eppeng
permitRS.Fields("per_edate") = eppdate
permitRS.Fields("per_etime") = epptime
permitRS.Fields("per_emt") = eppdh
permitRS.Fields("per_bran") = eppbran
permitRS.Fields("per_site") = eppsite
permitRS.Fields("per_cce") = eppcost
permitRS.Fields("per_deph") = " "
permitRS.Update
Go raibh maith agat
~M