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, ..
|
|