Character limit in SQL propery of a QueryDef? 2

[saraUSIT]

I'm trying to work with the sql property in a querydef but it seems like the sql keeps on getting truncated at around 250 characters- I know that the sql is somewhat lengthy, but I wanted to know if there was a way for the sql property to hold more than 250 characters? I am using the sql from the querydef in a variable in my code and then, if necessary (depending on other variables), adding some more criteria to the sql statement and then putting that back into the querydef before executing it. Any help in this matter is appreciated.
Thanks

 

[PHV]

the sql keeps on getting truncated at around 250 characters
Really ?
How did you do that ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[saraUSIT]

This is the beginning of my code:

Public Sub GetSkuSold(strQueryName As String)
Dim strSQL 
Dim origStrSQL As Variant, begStrSQL, endStrSQL, x, ctStrClause
Dim minDt, maxDt, intPos1 As Integer, intPos2 As Integer
   Dim ctCriteriaGrtr, ctCriteriaLess

Dim db As Database
Dim qd As DAO.QueryDef
Set db = CurrentDb
Set qd = db.QueryDefs(strQueryName)

origStrSQL = qd.sql
strSQL = origStrSQL

I was checking the variables in the locals screen and I noticed that the sql for the qd was not complete - it got truncated at around 250 characters from the sql statement that was in the query.

 

[PHV]

And what about this:
MsgBox origStrSQL
or this ?
Debug.Print origStrSQL

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[MajP]

That is the limit of the locals screen. I beleive the sql limit is 64,000 characters

http://blogs.msdn.com/access/archive/2006/06/05/access-2007-limits.aspx

 

[saraUSIT]

Thank you PHV and MajP - I got it to work! I didn't realize that the problem was just the locals screen... Thanks again for your help.