I am new to Progress.
We are trying to import a field from a Progress table into MS Access. We have been able to import the table using Intersolve ODBC, however, we are running into a problem with not getting all the information from a text field in Progress. In looking at the _Field table in Progress I noticed that the character field is of length 210 but when we inport this into MS Access we only get the first 60 characters of data. I was given some code to use to view the entire contents of the field using the Progress editor, but am unable to create the same process using MS Access. The specific code is :
for each app_comment no-lock where app_comment.appno = 4696.01:
display app_comment.AppNo
app_comment.Comment view-as editor inner-chars 80 inner-lines 5
with 3 col
I would appreciate any help that is available in solving this problem. Thanks in advance.
hi patrick,
you should modify your access-field. the standard option of an text-field in access is 50 characters. first step: modifiy the text-field in access. second step: import the table !!!!
i hope the trouble is than gone.
if not contact me.
kind regards
heiko
"Keenan" wrote:
>
>I am new to Progress.
>
>We are trying to import a field from a Progress table
>into MS Access. We have been able to import the table
>using Intersolve ODBC, however, we are running into a
>problem with not getting all the information from a text
>field in Progress. In looking at the _Field table in
>Progress I noticed that the character field is of length
>210 but when we inport this into MS Access we only get
>the first 60 characters of data. I was given some code
>to use to view the entire contents of the field using
>the Progress
>editor, but am unable to create the same process using
>MS Access. The specific code is :
>
>for each app_comment no-lock where app_comment.appno =
>4696.01:
>display app_comment.AppNo
>app_comment.Comment view-as editor inner-chars 80 inner-lines
>5
>with 3 col
>
>I would appreciate any help that is available in solving
>this problem. Thanks in advance.
Heiko,
I appreciate the help.
We have set the field in the local table to Text (255) length and also to Memo, which is unlimited length. We still only get the first 60 characters of data from the Progress table. We have tried importing the table from Progress and still the field says Text (60).
I believe that there is something in MS Access that will not convert the data type correctly when looking at the Progress table. Have you ever seen anything like this before?
Thanks again,
Keenan
"H. Zimmer" wrote:
>
>
>
>
>hi patrick,
>
>you should modify your access-field. the standard option
>of an text-field in access is 50 characters. first step:
>modifiy the text-field in access. second step: import
>the table !!!!
>
>i hope the trouble is than gone.
>
>if not contact me.
>
>kind regards
>heiko
>
>
>"Keenan" wrote:
>>
>>I am new to Progress.
>>
>>We are trying to import a field from a Progress table
>>into MS Access. We have been able to import the table
>>using Intersolve ODBC, however, we are running into a
>>problem with not getting all the information from a text
>>field in Progress. In looking at the _Field table in
>>Progress I noticed that the character field is of length
>>210 but when we inport this into MS Access we only get
>>the first 60 characters of data. I was given some code
>>to use to view the entire contents of the field using
>>the Progress
>>editor, but am unable to create the same process using
>>MS Access. The specific code is :
>>
>>for each app_comment no-lock where app_comment.appno
>=
>>4696.01:
>>display app_comment.AppNo
>>app_comment.Comment view-as editor inner-chars 80 inner-lines
>>5
>>with 3 col
>>
>>I would appreciate any help that is available in solving
>>this problem. Thanks in advance.
>