I am trying to pass an sql ntext field from a persistant class to the 
business object in the client. ntext is the same thing as a string but to 
assign a user type with mixed variable types I need to define a specific 
length.

Example:

Public Type AdmCodeProps
  AdmCode As String * 12
  Description As String * 20
End Type

Public Type AdmCodeData
  Buffer As String * 32
End Type

Then I can pass the AdmCodeProps by

  Dim udtData As AdmCodeData
  dim mudtProps As AdmCodeProps
  
  LSet udtData = mudtProps

This only works if the String length is known. With ntext I do not know 
the length at design time to set this and ntext's maximum length is 
1,073,741,823 characters. I obviousely do not want to dim my variable to 
this.

Does anyone have a solution to passing buffer data with ntext or images 
from one tier to the next?