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

This field PER_DDATE does not accept null values 

If you do not include in your insert "permitRS.AddNew...and fields" the field PER_DDATE 

" permitRS.Fields("per_ddate") = xxx " the value inserted in this field will be null





Sorry but my English not is good

Good Luck









Fabio Ferreira Balota

What is your opinion for using ADO RDS for a web site? Isn't it really for

intranet apps that have tight control over the client software. My clients

are not that computer literate and I want to make as thin of a client as

possible.



Your opinion please.





-----Original Message-----

From: Fabio Ferreira Balota [mailto:ffbalota@u...]

Sent: Thursday, February 07, 2002 2:13 PM

To: ASP_ADO_RDS

Cc: Fabio Ferreira Balota

Subject: [asp_ado_rds] RE: foxpro recordset null values





This field PER_DDATE does not accept null values

If you do not include in your insert "permitRS.AddNew...and fields" the

field PER_DDATE

" permitRS.Fields("per_ddate") = xxx " the value inserted in this field will

be null





Sorry but my English not is good

Good Luck









Fabio Ferreira Balota

I have had no problems learning ado rds from scratch so i would say that 

they are the way to go, even if your clients are not that computer literate







> What is your opinion for using ADO RDS for a web site? Isn't it really 

for

> intranet apps that have tight control over the client software. My 

clients

> are not that computer literate and I want to make as thin of a client as

> possible.

> 

> Your opinion please.

>