ODBC Error- Exceeding its max length -Vantage 6.1 Merant Dri

Yahoo Archive
1
I'm having the problem within Crystal and have not been able to resolve
it using the method below.

For some reason fields with a type of Memo are not available for Crystal
formulas or Sql expressions.



Rob



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Olson, Brian
Sent: Monday, March 19, 2007 10:37 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC Error- Exceeding its max length -Vantage 6.1
Merant Driver



Thanks.......Any ideas about crystal reports?



-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]On
Behalf Of Mark Wonsil
Sent: Friday, March 16, 2007 3:25 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] ODBC Error- Exceeding its max length -Vantage 6.1
Merant Driver

> We are having trouble with the part desctiption being too large and
the
> merant driver is giving us the following error ODBC error Datadirect -
> Technologies Part Description in table """ has value exceeding its max
> length or precision.
>
> Has anyone got a solution....thanks

In your SQL statement, limit the size of the field by using the SUBSTR
function:

SELECT SUBSTR(PartDescription, 1, 100) shortPartDesc
FROM PUB.Part

This is work if you're using a pass-thru query and I would imagine if
you want
the whole description, you can pull it down in pieces:

SELECT SUBSTR(PartDescription, 1, 100) PartDesc1,
SUBSTR(PartDescription, 101, 100) PartDesc2
FROM PUB.Part

Mark W.

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
2
We are having trouble with the part desctiption being too large and the
merant driver is giving us the following error ODBC error Datadirect -
Technologies Part Description in table """ has value exceeding its max
length or precision.

Has anyone got a solution....thanks
3
I'm having the same problem with the Labor Notes field.



Rob



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian
Sent: Friday, March 16, 2007 3:42 PM
To: vantage@yahoogroups.com
Subject: [Vantage] ODBC Error- Exceeding its max length -Vantage 6.1
Merant Driver



We are having trouble with the part desctiption being too large and the
merant driver is giving us the following error ODBC error Datadirect -
Technologies Part Description in table """ has value exceeding its max
length or precision.

Has anyone got a solution....thanks





[Non-text portions of this message have been removed]
4
> We are having trouble with the part desctiption being too large and the
> merant driver is giving us the following error ODBC error Datadirect -
> Technologies Part Description in table """ has value exceeding its max
> length or precision.
>
> Has anyone got a solution....thanks

In your SQL statement, limit the size of the field by using the SUBSTR
function:

SELECT SUBSTR(PartDescription, 1, 100) shortPartDesc
FROM PUB.Part

This is work if you're using a pass-thru query and I would imagine if you want
the whole description, you can pull it down in pieces:

SELECT SUBSTR(PartDescription, 1, 100) PartDesc1,
SUBSTR(PartDescription, 101, 100) PartDesc2
FROM PUB.Part

Mark W.
5
Thanks.......Any ideas about crystal reports?



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Mark Wonsil
Sent: Friday, March 16, 2007 3:25 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC Error- Exceeding its max length -Vantage 6.1 Merant Driver



> We are having trouble with the part desctiption being too large and the
> merant driver is giving us the following error ODBC error Datadirect -
> Technologies Part Description in table """ has value exceeding its max
> length or precision.
>
> Has anyone got a solution....thanks

In your SQL statement, limit the size of the field by using the SUBSTR
function:

SELECT SUBSTR(PartDescription, 1, 100) shortPartDesc
FROM PUB.Part

This is work if you're using a pass-thru query and I would imagine if you want
the whole description, you can pull it down in pieces:

SELECT SUBSTR(PartDescription, 1, 100) PartDesc1,
SUBSTR(PartDescription, 101, 100) PartDesc2
FROM PUB.Part

Mark W.







[Non-text portions of this message have been removed]