> I'm wondering if anyone has had success importing data to a memo field using
> PARADOX FOR WINDOWS 4.5.
> exceeds the 240-character-limit, necessitating a memo field. Fine. But I can't
> find anything (in writing) by Borland that definitively shows how to import
> to a memo field.
I found a quick poke around the Memo data type section of the reference manual did the trick, but
it could have been better explained...
> Can anyone help?
See example below (it's butchered a bit from what we actually use, but
only because we also do graphic import and/or a bit of character filtering in
the same routine).
method importDetail(var dtc Tcursor,filename String) Logical
var succeeded Logical
succeeded = memoData.readfromfile(filename) ;here's the gist
if succeeded then
if not dtc.insertrecord() then ; problem
msginfo("Details Import","Unable to append record for "+filename)
maxID = getMaxID(dtc.tablename()) ;you can guess
if maxID >=0 then ; else error msg in getMaxID()
dtc.Txt= memoData ; Txt is a memo field
dtc."Detail ID"= maxID
return True ; succeeded!
endif ; maxID
endif ; insert
endif ; readin succeeded
Peter Hyde, South Pacific Information Services Ltd
Christchurch, New Zealand - one world away from reality