B4J Question net.sourceforge.jtds.jdbc.ClobImpl ?! RDC Client

[alienhunter]

Hi Erel
how do i read something like this back with the RDC Client ?
i never seen this one

http://jtds.sourceforge.net/doc/net/sourceforge/jtds/jdbc/ClobImpl.html
is this a Text BLOB ?

Thanks AH

 

[Erel]

It should return as an array of bytes.

 

[MrKim]

I, too am confused. The following query in RDC.

sql.GetPartMasterPicsQry=SELECT PartMasterPics.Pmp_PictureName, PartMasterPics.Pmp_Notes, PartMasterPics.Pmp_PrintOnTrav FROM PartMasterPics WHERE (((PartMasterPics.Pmp_PmLinkID)=?)) ORDER BY PartMasterPics.Pmp_SortOrder;

Returns:

The first and last field are fine. I have no idea what to do with the second. It should be returning a line or so of text.
here is the relevant code:

Dim result As DBResult = reqManager2.HandleJob(Job)
If result.Tag = "GetPartMasterPicsQry" Then
   For Each records() As Object In result.Rows
      PicsList.AddTwoLines2(records(0), records(1), records(0))
   Next
End IF

The field in SQL Server is nvarchar(MAX). Perhaps the easiest thing to do is CAST it to a regular text in the query?

 

[MrKim]

Interesting, I solved the problem by changing the query and Changing the return field type:

SELECT PartMasterPics.Pmp_PictureName, Cast(PartMasterPics.Pmp_Notes AS nvarchar(100)), PartMasterPics.Pmp_PrintOnTrav FROM PartMasterPics WHERE (((PartMasterPics.Pmp_PmLinkID)=19890)) ORDER BY PartMasterPics.Pmp_SortOrder;

But I would still like to know how to handle very long note fields in the future.

 

[Erel]

A clob is handled like a blob. You can use BytesToString keyword to convert it to a string.

 

[MrKim]

A clob is handled like a blob. You can use BytesToString keyword to convert it to a string.

Thanks, so much to remember!