Hi all,
I have a query in ASP.NET that selects text from a memo field in Access
(among other things). The query appears to be truncating the text at
255 characters. I've done a little research on this and found some
other Google Groups threads that were helpful, but I still don't have a
solution. My query is rather complicated and uses a union, but not the
keyword distinct. The query is displayed in a datagrid, and I don't
know how I would be able to break it up to solve the 255 problem and
still have it display in the one datagrid. Is there anything I can add
to it? Here's the query:
(Select pk_characteristic_id, vc_characteristic_name,
pk_description_id, tx_description From ((tb_descriptions d inner join
tb_agents a on d.fk_agent_id = a.pk_agent_id) inner join
tb_characteristics c on d.fk_characteristic_id =
c.pk_characteristic_id) where d.fk_agent_id = @agentID) UNION (select
pk_characteristic_id, vc_characteristic_name, 0 AS pk_description_id,
'' from tb_characteristics where pk_characteristic_id NOT IN (select
fk_characteristic_id from tb_descriptions where fk_agent_id =
@agentID))
Is there a solution to my problem, or am I going to have to switch
databases? Please help!
Thanks!
Anna