Long strings show garbage???

[Phailak]

Hail,

I have a recordset (ADO) that should return a string of about 308 characters in one of the fields, instead it returns almost the whole string then cuts off and either shows garbage characters or nothing at all depending on each run??? Is it because the string is more than 255 characters? Anyone have any idea why it's doing this?

Phailak

[si_the_geek]

It could be a 255(ish) limit.

What database system are you using (Access/SQL Server/etc)?
What data type is the field that has the issue?

[Phailak]

It could be a 255(ish) limit.

What database system are you using (Access/SQL Server/etc)?
What data type is the field that has the issue?

It is a 255 limit thing. I'm using Access 2003, and the field basically concatenates a few Memo fields, guess it doesn't like that...

[si_the_geek]

Ah yes, Memo is a strange data type unfortunately.

How are you concatenating?

[Phailak]

Just putting field1 & ' - ' & Field2 & ' - ' & field3... up to field5

All records under 255 work fine

[si_the_geek]

I would recommend bringing back the fields seperately, then concatenating them in your program.

If this isn't possible (or it doesnt work), where are you displaying the data? (nb: if you are looking at it in the Watch window in VB, that can only show 255 chars).

[randem]

Phailak,

If you must use a large amount of data in a field in Access use the Ole Object field. Use GetChunk and AppendChunk to manipulate the data.

[Phailak]

I'm using data report to display the data, so I have to use a recordset right? Also means I cannot bring them in seperately...

[randem]

Phailak,

Translation Please....

[dee-u]

I have a recordset (ADO) that should return a string of about 308 characters in one of the fields, instead it returns almost the whole string Phailak

I can't understand the above sentence, if you are retrieving the data from the field of course it will return the whole string and not just 308 characters.

then cuts off and either shows garbage characters or nothing at all depending on each run??? Is it because the string is more than 255 characters? Anyone have any idea why it's doing this?

How are you saving in the field? Those garbage maybe vbCrLf characters... Are you using Memo? If you are then it could handle more than 255 characters...

[si_the_geek]

The trouble is that Phailak is combining a few memo fields, and unfortunately due to the usage it does need to be in the SQL.

You'll need to work the data a bit, I'm not sure quite how tho. Try these methods to see if they help:

Trim(field1) & ' - ' & Trim(Field2) & ' - ' & ...

Left(field1,Len(field1)) & ' - ' & Left(Field2, Len(Field2)) & ' - ' & ...