ADO recordset update can't handle field name [Acct #] ? - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

ADO recordset update can't handle field name [Acct #] ?

Message

From

20/12/2001 10:14:55

John Baldwin
MCI
Fort Lauderdale, Florida, United States

To

19/12/2001 16:27:09

John Baldwin
MCI
Fort Lauderdale, Florida, United States

General information

Forum:

Visual Basic

Category:

Database DAO/RDO/ODBC/ADO

Title:

Re: ADO recordset update can't handle field name [Acct #] ?

Miscellaneous

Thread ID:

00596451

Message ID:

00596758

Views:

17

I have now tried these options, still with no success.

recordset.Fields(0) = '123'
recordset.Fields("Acct #") = '123'
recordset(0) = '123'

recordset.UpdateBatch

The error msg I get when using any of these options is: The INSERT INTO statement contains the following unknown field name: 'Acct #'.

If I debug this, I can see that the assignment is made correctly & I can see the field name as [Acct #]. It is when the UpdateBatch executes that I get the error message.

Thoughts?

Click here to load this message in the networking platform