[AccessD] [dba-VB] Multiple-step operation generated errors - check each status value

I'm a little puzzled now, I have just tried removing those lines of code from my program and I still get the Multiple step operation error ????, and it looks like it's the Ethnicity field.
Anyone have a possible solution to this.  Thanks in advance.
Paul Hartland 





Message date : Jan 09 2004, 02:20 PM
>From : Mike & Doris Manning 
To : 'Access Developers discussion and problem solving' 
Copy to : 
Subject : RE: RE: [AccessD] [dba-VB] Multiple-step operation generated errors - check each status value
Look at your comparison, you are comparing to vbnullstring ("") and not 0.
Also you are trying to store a string into an int

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
paul.hartland at fsmail.net
Sent: Friday, January 09, 2004 8:16 AM
To: Access Developers discussion and problem solving
Subject: Re: RE: [AccessD] [dba-VB] Multiple-step operation generated errors
- check each status value


I know, but surely the tinyint data type accepts zero's or am I still
missing something ?





Message date : Jan 09 2004, 01:04 PM
>From : Mike & Doris Manning
To : 'Access Developers discussion and problem solving' 
Copy to : 
Subject : RE: [AccessD] [dba-VB] Multiple-step operation generated errors -
check each status value A combo box bound to an Integer field will have a 0
after the user deletes the entry.

Doris Manning
Database Administrator
Hargrove Inc.
www.hargroveinc.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
paul.hartland at fsmail.net
Sent: Friday, January 09, 2004 5:24 AM
To: dba-vb
Cc: accessd
Subject: [AccessD] [dba-VB] Multiple-step operation generated errors - check
each status value


To all,

I have a Visual Basic 6 FE which is connecting to a SQL Server 7.0 BE. One
of my fields is called EthnicOrigin which is a TinyInt data type, which also
allows Null. The control on the form is a DataCombo, with the list field
being Ethnicity and the BoundColumn being EthnicityID. When a user selects
an Ethnicity all is well no problem with updating etc as the EthnicityID is
entered into the Field and the DataCombo display the Ethnicity. If the user
deletes the entry from EthnicOrigin then when the record tries to update I
get the error 

Multiple-step operation generated errors - check each status value

Below is the code for updating:
With rsPersonnel
If (frmOrrPersonnel.PVEthnic <> "") Then
.Fields("EthnicOrigin") = frmOrrPersonnel.PVEthnic.BoundText
Else
.Fields("EthnicOrigin") = 0
End If
.Update
End With

Can anyone tell me what I am doing wrong ?

Thanks in advance for any help as this is really starting to frustrate me.

Paul Hartland
Freeserve AnyTime - HALF PRICE for the first 3 months - Save £7.50 a month 
www.freeserve.com/anytime _______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-vb
http://www.databaseadvisors.com

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
Freeserve AnyTime - HALF PRICE for the first 3 months - Save £7.50 a month 
www.freeserve.com/anytime _______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
Freeserve AnyTime - HALF PRICE for the first 3 months - Save £7.50 a month 
www.freeserve.com/anytime