Build SQL statement longer than 1024

  • Thread starter Thread starter iccsi
  • Start date Start date
I

iccsi

I build my SQL statement using VBA code and it is longer than 1024
characters. It seems that it reaches limitations of MS Access one
query cell limitations.

Does SQL consider built SQL statement using VBA as a cell?


Are there any work around for this?

Your help is great appreciated,
 
There's no 1024 character limitation that I'm aware of. Let's see what your
code looks like.
 
I build my SQL statement using VBA code and it is longer than 1024
characters. It seems that it reaches limitations of MS Access one
query cell limitations.

Does SQL consider built SQL statement using VBA as a cell?


Are there any work around for this?

Your help is great appreciated,
Click to expand...

A query can be far bigger than 1024 characters - 65KBytes if I recall
correctly.

Please post your code. The SQL should indeed not be "in a cell".
 
A query can be far bigger than 1024 characters - 65KBytes if I recall
correctly.

Please post your code. The SQL should indeed not be "in a cell".
Click to expand...



Dim AqdfCurr As DAO.QueryDef
Dim strStub As String

strStub = " SELECT * FROM Mytable......."
' it has a query more than 1024 characters

Set AqdfCurr = CurrentDb().QueryDefs("MyQuery")
AqdfCurr.SQL = strStub

I use Debug.Print strStub and paste to the query design that it
separate in 2 parts and got error. it works when I delete the space
between them.
The immediate windows shows the SQL statement reaches the miximum of
the windows.

In the stament, there is no space beteen them.


Thansk again,
 
 Dim AqdfCurr As DAO.QueryDef
 Dim strStub As String

strStub = " SELECT * FROM Mytable......."
' it has a query more than 1024 characters

Set AqdfCurr = CurrentDb().QueryDefs("MyQuery")
AqdfCurr.SQL = strStub

I use Debug.Print strStub and paste to the query design that it
separate in 2 parts and got error. it works when I delete the space
between them.
The immediate windows shows the SQL statement reaches the miximum of
the windows.

In the stament, there is no space beteen them.

Thansk again,- Hide quoted text -

- Show quoted text -
Click to expand...

Thanks millions for helping,
The problem is in my SQL statement.
Thanks again,
 
Back
Top