Help needed: reading access 2000 memo fields

by Karl Francis Horva » Fri, 13 Apr 2001 11:19:49

Hi,
Which JDBC resultset method do I use to retrieve the data from an Access 2000
memo field ?

rs.getString(n) results in an "out of memory error" and getClob(n) also results
in an error. How do I access such a potentially large field ? under
ASP/Vbscript it's fairly transparent as it's just read as text, but with JDBC I
am having problems.

thanks in advance,
Karl.
remove the nojunk to email me.

Top

1. Need help accessing Paradox memo fields as TMemos

How can I read the text from a Paradox Memo field? I need to read several
memo fields (from different records in the same table) into several
TMemo variables (created at run time) on the same form. (TDBMemo is not
useful in this case). The memo field contents may be of any length.

Having added the proper TTable object to my form, and added the Paradox
Memo field to my fields list as a TMemoField, I am unable to access the
contents of the memo field.

The TMemofield property Astring yields (Memo) which is of no use.

The Tmemofield property Text yields (Memo), and seems generally
useless as it holds a max of 255 chars in a TMemo.

I have also tried to use the Tmemofield GetData method as follows...

var Buffer: PChar;

GetMem(Buffer,MemoField.DataSize+1);
if not MemoField.GetData(Buffer) then
MessageDlg('TMemofield is NULL', mtInformation, [mbOK], 0)
else
begin
Buffer:=StrCat(Buffer,#0);
{ do something with Buffer }
end;
FreeMem(Buffer,MemoField.Size+1);

...but the GetData method gives a GPF (Operation not Applicable)

(I also tried it with an untyped pointer, with the same result)

This seems like a very common type of data access. What should I be doing?

Thanks, in advance.

Dave.

2. Does IT matter?

3. need help opening a two field index with VB6 using access 2000

4. Putting a picture in Access using vb code

5. Importing Access memo fields to SQL Server 2000

6. What is GetCollect?

7. Access 2000 memo type fields don't display on my ASP pages

8. Invalid URL