Eric Barro
ebarro at afsweb.com
Fri Jan 9 09:11:02 CST 2004
Paul,
Check the record lock type you defined for the recordset.
---
Eric Barro
Senior Systems Analyst
Advanced Field Services
(208) 772-7060
http://www.afsweb.com
-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com]On Behalf Of
paul.hartland at fsmail.net
Sent: Friday, January 09, 2004 2:24 AM
To: dba-vb
Cc: accessd
Subject: [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
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.555 / Virus Database: 347 - Release Date: 12/23/2003
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.555 / Virus Database: 347 - Release Date: 12/23/2003