dbTalk Databases Forums  

A query not working...

comp.database.ms-access comp.database.ms-access


Discuss A query not working... in the comp.database.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
alessandro
 
Posts: n/a

Default 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!

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.