HELP! - importing text to memo fields

HELP! - importing text to memo fields

Post by Jerome Smi » Fri, 23 Jun 1995 04:00:00



I've asked this question a couple of times with no luck in getting any
response...but I'll try again:

Has anyone had any luck (or experience) importing large blocks of text
into memo fields?  I have about 1000 records worth of text, each record
is between 2-4000 characters.  They are all variable in length.  I'm
trying to import them into memo fields.  I've used one of the import
tools found on PDX Informant BBS - however...it fails to bring in the
whole record.  It dies around 1046 characters  - apparently the limit
of a readline command.

Any help in this area would be appreciated.

 
 
 

HELP! - importing text to memo fields

Post by j.. » Fri, 23 Jun 1995 04:00:00


The readLine method will only read 1023 characters (see online help in 5.0) at a  
time.  Use a sePosition to skip the first 1023 characters abd readLine again.    
Repeat until you are at the end of the file.

Good luck.

 
 
 

HELP! - importing text to memo fields

Post by Brian Ivi » Fri, 23 Jun 1995 04:00:00



>I've asked this question a couple of times with no luck in getting any
>response...but I'll try again:

>Has anyone had any luck (or experience) importing large blocks of text
>into memo fields?  I have about 1000 records worth of text, each record
>is between 2-4000 characters.  They are all variable in length.  I'm
>trying to import them into memo fields.  I've used one of the import
>tools found on PDX Informant BBS - however...it fails to bring in the
>whole record.  It dies around 1046 characters  - apparently the limit
>of a readline command.

>Any help in this area would be appreciated.

********************************************
I tried a little OPAL, I hope this helps...
-----------------------------------------------------------------------
method pushButton(var eventInfo Event)
var
  mm    Memo    ; To store temporarily the memo
  tc    tCursor ; A tCursor to whatever table you want to place the memo
endVar

mm.readFromFile ("THE NAME OF THE TEXTFILE")) ; To read in the text
tc.open(":WORK:TRY.DB")) ; The following to save the text
  tc.edit()
  tc.insertRecord()
  tc."memo" = mm
tc.close()
endMethod

********************************************
Brian Ivie
Computer Specialist
CES Youth and Family Programs

(801) 378-6353