Click to See Complete Forum and Search --> : long text in database???


junmanjit
October 3rd, 2000, 08:19 PM
How can I put a long text in database?
I have a kind of information which is kind of long text format. Can I put it directly into database, or I should put a txt file name into database only?

I prefer to putting all the words into database directly.
Any suggestions?

Cheers.

Rabold
October 11th, 2000, 03:03 AM
I put long text in a memo field (access) using get chunk and append chung method

Code:
...
Do Until rstStringinterface.EOF
With rstStringinterface

If !id < 100 Then
.MoveNext
Trace "Skipping ID" + CStr(!id)
Else
pByte = rstStringinterface.Fields(strKennung).GetChunk(coMaxStringLengthofResourceManager)

.....

AR