Recordset Field Size Limit?

[dftjsn]

I am creating a recordset from an SQL select statement. The SQL concatenates several fields together to form one long field: Citation. Some citations work out to be greater than 255 characters in length. The SQL statement works and the Citations in the recordset look fine except when the length is greater than 255 characters ... whereupon there is garbage in the record from character 256 on out to its end. Are fields in Recordsets strings and therefore limited to 255 characters? Can the Recordset field length be changed?

Thanks!

dftjsn

 

[Junior1544]

try using field type memo. junior1544@jmjpc.net
Life is change. To deny change is to deny life.

 

[dftjsn]

Junior1544,

A field type of memo is not an option as I'm not defining a new table structure. I'm creating a recordset from an SQL select statement. The SQL statement concatenates several table fields into one larger field for the recordset. Unfortunately, the length of the returned recordset field: rst!Citation is sometimes greater than 255 characters in length which gives me junk after character 255. The rst!Citation.DefinedSize property shows that the citation field length in the recordset is 255.

Anyone have any ideas other than not concatenating into one field (the recordset is for input to another control that can only have one field)?

Thanks!

dftjsn

 

[gravesend]

dftjsn,

I have the same problem as you, and was wondering if you've found a solution.

my problem is where i load an excel field into a recordset object in asp. the fields larger than 255 characters get cut off. let me know if you've found a solution!

thanks.

 

[gravesend]

dftjsn,

i found the answer for my problem. this may or may not give you a clue to solving your problem:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;189897

 

[drat242]

I need to create a form.recordsource from an SQL string that is longer than 255 chars. Apparently form.recordsource cannot be longer than 255??

Is there a way to create a recordset from the SQL statement and then use this as te recordsource for a form?

Thanks
drat242