c**t
发帖数: 2744 | 1 I use ADO 2.0 library in VB to get data from MSAccess, and find a bug:
if the recordset has a memo field in the middle, the rest fields will be
ignored. (There are newline in the memo field).
Does anybody else have the similar issue? If I put the memo field at the
end of select statement, the problem will go away. But if having two memo
fields, I don't have idea to retreive data. :-(
And how to update memo field with update statement? I can't think out a way
to escape newline, sigal quote, .. | s*****a
发帖数: 1022 | 2 Does this bug still exist in ADO 2.8?
【在 c**t 的大作中提到】
: I use ADO 2.0 library in VB to get data from MSAccess, and find a bug:
: if the recordset has a memo field in the middle, the rest fields will be
: ignored. (There are newline in the memo field).
: Does anybody else have the similar issue? If I put the memo field at the
: end of select statement, the problem will go away. But if having two memo
: fields, I don't have idea to retreive data. :-(
: And how to update memo field with update statement? I can't think out a way
: to escape newline, sigal quote, ..
|
|
