Load command and characters in field 
Author Message
 Load command and characters in field

Hi,

I am trying quite unsuccessfully to load a file that was originally a
Foxpro file into Informix.  The problem is most of the Foxpro fields
were memo fields with lots of carriage returns.  It appears that
Informix sees these carriage returns as a new record which is not the
case.  It is merely a new paragraph within the same field. I end up
with an error message implying that the number of fields in the
informix file do not equal the number of fields in the Foxpro file.
It does, but since Informix reads the carriage returns as a new
record instead of just recogizing the delimiter, it counts wrong.
Following me?  

Does anyone know a way I can work around this problem without
deleteing all the carriage returns within each field?

Thanks in advance

Bonnie



Tue, 23 Apr 1996 06:57:37 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. DBLib character field loading question

2. writing 1024 characters in a varchar-field with allows 8000 characters doesn′t work

3. Insert characters to existing character field

4. Space characters in character field

5. Create a primary key with a numeric field and a character field

6. SQL7 - Errors when updating a field with more characters than the field

7. Help: DBMemo in character-field (not Memo-field)

8. ( field + 0 ) to order character ( number ) fields ??

9. Import delimited data -- How do I keep fields with numeric character from becomming number fields

10. convert a character field to a date field

11. Move Character field contents to Date field

12. using a dbedit field to load a picture in an image field


 
Powered by phpBB® Forum Software