I am trying to build a string argument for an sql statement as
follows:
Dim sSql As String
sSql = ""
sSql = "SELECT DISTINCT Office.OfficeKey, Office.Office "
sSql = sSql & " FROM (Offices INNER JOIN LinkLionOffice ON
Offices.OfficeKey = LinkLionOffice.OfficeKey) "
sSql = sSql & " INNER JOIN (Districts JOIN Clubs ON
Districts.DistrictKey = Clubs.DistrictKey) "
sSql = sSql & " ON LinkLionOffice.ClubKey = Clubs.ClubKey"
sSql = sSql & " Where District.DistrictKey = " & iDistrictKey
sSql = sSql & " ORDER BY Office;"
The string is getting truncated at about 150 characters and my query
naturally fails. I have seen this phenomenon before, but have not
been able to come up with any reason for it or solution. I have also
developed databases where this problem has not occurred.
I have tried running the string all on to one line, and also using &
_ with the same result.
I must be missing something. Is it possible that I've somehow
limited the length a string can be? (The help file says they can be
about 2 billion characters) Any help would be appreciated.
Thanks,
Steven Wasserman
------------------------ Yahoo! Groups Sponsor --------------------~-->
<font face=arial size=-1><a
href="http://us.ard.yahoo.com/SIG=12hi5m593/M=362131.6882499.7825260.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1122770016/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org
">Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life
- brought to you by One Economy</a>.</font>
--------------------------------------------------------------------~->
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
