by S » Fri, 21 Dec 2001 11:32:25
Thanks for your help.
Scott
--
****Remove the obvious from my address to reply****
by Val Mazu » Sat, 22 Dec 2001 02:18:35
To read from memo fields you need to use GetChunk method
of Filed object. It allows to read "long" data (text,
binary) from field. AppendChunk is for saving data into
memo/binary field
Val
Quote:>-----Original Message-----
>I've got an Access 2000 database that has a field of
typ "memo". When
>I get this in a recordset, how to I access it? For
example, lets say
>I want to put the first 200 chars into a label, how do I
get them out?
>Do the string manipulators work with memo?
>Thanks for your help.
>Scott
>--
>****Remove the obvious from my address to reply****
>.
1. Error while inserting memo datatype in Access
Server: Msg 8626, Level 16, State 1, Line 1
Only text pointers are allowed in work tables, never text, ntext, or image
columns. The query processor produced a query plan that required a text,
ntext, or image column in a work table.
This is the query
insert tests
select lTestID,lTestSeq,ctExecutionDate,strStation,
strOperator,memoNotes
from OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'\\slss\d$\CS.mdb';'admin';'', tests)
AS xyz
where not exists ( select * from tests t where t.ltestid = xyz.ltestid )
Now the memoNotes field is of datatype memo in Access and of type text in
SQL.
Currently the values in Access for that column are Null . There are only 12
rows in Access.
SO how do i resolve this ?
2. Paradox 4.5
3. What datatype to use for Access memo fields?
4. Tools for Oracle Developers released as free-ware
5. SQL7 Datatypes for Access memo fields
6. Performance Issues with Oracle database and Web server
7. Convert Access memo datatype to SQL Server text type
9. Access 2000 Memo DataType - URGENT
10. Access 2000 memo datatype to JDBC
11. Mapping ADO datatype to SQL Server datatype?
12. ADO DataType Enum Mapping To SQL DataTypes
13. Updating Memo Fields in MS Access using ADO Parameter / Stored Procedures