large String

[mike009]

hi i want to add very large selece statement into a string in vba , how can i do this
the selesct statement has 800 char

when i try to add it to string it addes he first 256 char only
any idea
thx

 

[EMP]

How did you add your large select statement to the string?


The following is from Access' help file, Access 2K:-

String Data Type

A variable-length string can contain up to approximately 2 billion (2^31) characters.

^

 

[iovchevski]

iovchevski

it will have to be by doing in in several rows. I belive that each row can be marked so vb knows it continues in the next row with _(underscore) ending and beginning.

I hope this helps

example:

select bla bla bla dfgdfgdfgsdfgdfgsdfgsdfg _
_ hkfbkhgfjhdgjgjhgjhgj;

 

[WayneRyan]

io,

Multiple lines, but still human-readable.

strSQL = "Select Field1, Field2, Field3 " & _
         "From   SomeTable " & _
         "Where ..."

Wayne