A query not working... -
09-01-2004
, 11:48 AM
Hi you all,
I need your help, please. I am writing a query within MSAccess to be
used from an external app like a ASP-JScript webpage or a Visual Basic
exe-app but now I am in trouble.
I have stored a query within MSAccess which returns exactly 5 fields as
you can see:
counter,
text(15),
text(5),
currency,
text(41) & text(15) & text(31) & text(14) & text(27) & text(186)
the 5th field is obtained as a concatenation of 6 fields sized as you
can see.
Now, when I execute this query it results giving out strange chars in
the 5th field even before the 255th character (when the content is
smaller than 255 chars). I can't understand how I can handle it, what
are your suggestions?
I wonder, could it be this because the resulting field goes over the 255
chars (exactly 314 chars), the max size of a char field in MSAccess?
Thank you in advance for your help,
ilvecchioalex
--
Per rispondermi tieniti... ilregalo!
Keep... "ilregalo" to answer! |