I have notice a number of ODBC problems pertaining to memo fields or
BLOB fields lately. I wanted to post and make sure everyone knew the
root cause of these errors.
Both Crystal and Access can handle Memo fields the only Limitation is
that Crystal 8.5 can not use them in formula fields. The problems
stem from the ODBC driver, and the some what ridiculous schema
Vantage provides. The SQL width is the cause of the Max Length or
Precision errors which then cause crystal to report errors in the
database dll.
To view the SQL width of a field open you data dictionary. Not the
one in Vantage, Progress's version. Many of you will get a read-only
message. This is a problem because if you recieve this message you
can't change the SQL width. The SQL width in many fields is set much
to small. Some description fields are as low as 60. The kicker is
that the ODBC driver's width limit is 31995 characters. If you are
not read-only just increase the SQL width. You won't be able to
change schema when other users are in the database. I am looking for
a way to fix this problem for everyone. Vantage may have a fix, but
I haven't called them on this issue since I can edit my schema. If
anyone knows how to change this value with out .r code, I'm sure it
would help lots of people out. I look into writing a program to help
out. I will post it in the files section if I get it working.
BLOB fields lately. I wanted to post and make sure everyone knew the
root cause of these errors.
Both Crystal and Access can handle Memo fields the only Limitation is
that Crystal 8.5 can not use them in formula fields. The problems
stem from the ODBC driver, and the some what ridiculous schema
Vantage provides. The SQL width is the cause of the Max Length or
Precision errors which then cause crystal to report errors in the
database dll.
To view the SQL width of a field open you data dictionary. Not the
one in Vantage, Progress's version. Many of you will get a read-only
message. This is a problem because if you recieve this message you
can't change the SQL width. The SQL width in many fields is set much
to small. Some description fields are as low as 60. The kicker is
that the ODBC driver's width limit is 31995 characters. If you are
not read-only just increase the SQL width. You won't be able to
change schema when other users are in the database. I am looking for
a way to fix this problem for everyone. Vantage may have a fix, but
I haven't called them on this issue since I can edit my schema. If
anyone knows how to change this value with out .r code, I'm sure it
would help lots of people out. I look into writing a program to help
out. I will post it in the files section if I get it working.