-----Original Message-----
From: Troy Funte [mailto:
tfunte@...]
Sent: Thursday, May 15, 2003 10:23 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC
Ron,
I have never run into that error with a comment field, but have had
similar problems with the part description field, which is also a l o n g
field (blob, it is sometimes called). Crystal doesn't let you use formulas
on blob or memo fields that are beyond 250 characters. The answer in
Crystal is to use an expression that truncates the field to 250 characters.
Then it seems you can use it in formulas and groups.
Troy
-----Original Message-----
From: Ron Newell [mailto:
rnewell@...]
Sent: Wednesday, May 14, 2003 2:48 PM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC
Hi,
I am getting the following error when running a crystal report from
ODBC. Dose anyone know a work around? Any help would be appreciated.
" ODBC error: [MERANT][ODBC PROGRESS driver][PROGRESS]Column CommentText
in table PUB.JobHead has value exceeding max length or precision."
If I remove the JobHead.commentText field from the report it runs fine.
Thanks,
Ron Newell
IT Manager
Pattison Sign Group
165 Waterloo Ave.
Penticton, BC V2A 7J3
Phone: 250-492-4522 EX:101
Fax: 250-492-3462
http://www.pattisonsign.com <
http://www.pattisonsign.com>
mailto:
rnewell@...
Yahoo! Groups Sponsor
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<
http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<
http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<
http://groups.yahoo.com/group/vantage/links>
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
<
http://rd.yahoo.com/M=251812.3170658.4537139.1261774/D=egroupweb/S=17050071
83:HM/A=1564416/R=0/*
http://www.netflix.com/Default?mqso=60164797&partid=317
0658>
<
http://us.adserver.yahoo.com/l?M=251812.3170658.4537139.1261774/D=egroupmai
l/S=:HM/A=1564416/rand=111257204>
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<
http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<
http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<
http://groups.yahoo.com/group/vantage/links>
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<
http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]