String treated as a BLOB???

[jolly]

Hi Folks,

If I define a data item as a String length 1000, I can use it as a table column and include it in a business view.

If I define the data item as string length 2000, I can still use it as a table column but cannot include it in a busiess view; the system issues an error stating that a BLOB column cannot be included in a BSVW!

So what goves? Is there a string size limit at which point JDE treats it as a BLOB? Or is there some way to force the system to treat the 2kB string azs a string and not as a blob?


Note: Xe, SP22, AS400 DB2.

Cheers,
JohnO

 

[DBohner-(db)]

Jolly,



Are you using a JDE String that is 2K? Or are you creating your own sting
that is 2K?



If you are using a JDE String - is it already predefined as a blob?

(db)



_____

From: [email protected] [mailto:[email protected]] On
Behalf Of jolly
Sent: Thursday, November 10, 2005 5:26 PM
To: [email protected]
Subject: String treated as a BLOB???



Hi Folks,

If I define a data item as a String length 1000, I can use it as a table
column and include it in a business view.

If I define the data item as string length 2000, I can still use it as a
table column but cannot include it in a busiess view; the system issues an
error stating that a BLOB column cannot be included in a BSVW!

So what goves? Is there a string size limit at which point JDE treats it as
a BLOB? Or is there some way to force the system to treat the 2kB string azs
a string and not as a blob?


Note: Xe, SP22, AS400 DB2.

Cheers,
JohnO

OneWorld Xe Update 6 SP22, HP/UX, Oracle 8/9, AS400, Win2K, WinXP Check out
jdeLogCentral and jdeLogViewer at: http://www.f3software.com

_____


The entire <http://www.jdelist.com/ubb/showflat.php?Cat=&Board=> JDELIST
thread is available for viewing.


Looking for a job? Check out the Job
forum


This is the JDELIST EnterpriseOne Developers Mailing List.
The instructions on how to unsubscribe from any JDELIST mailing list are
available here <http://www.jdelist.com/unsubscr.shtml> .
JDELIST is not affiliated with JDEdwardsR.