Reentrant error message with requery

[Informed]

Why does the following ADO code running off a SQL 7 DB:

With rsReadTableInfo
.Open
.Find "TableName='Variables'"
.Resync adAffectCurrent
.MoveFirst
.Find "TableName='Salutations'"
.Resync adAffectCurrent
End With

generate this error message:

"Consumers event handler called a non-reentrant method in the provider"

The recordset is being opened as a server side, keyset with optimistic
locking.

Thanks, Rob.

 

[Cagliostro]

I think the problem is with double quetes what you should put.
"TableName=''Salutations''"
John Fill

ivfmd@mail.md

 

[Informed]

John,

It's not the find that generates the error - it's the second resync.

Also, .find "TableName=""Variables""" doesn't work. I think in the area of quotes (which is another problem), ADO should use single quotes.

Cheers, Rob.

 

[Cagliostro]

As you see, in the sample I put twice single quotes. John Fill

ivfmd@mail.md