Anyone know the StrSQL Character limitation off the top of your head?

  • Thread starter Thread starter Julie Alley
  • Start date Start date
J

Julie Alley

I might be running in to a larger update query statement.

Has anyone else dealt with this? If you have do you recall how you worked
around it?

Thanks,

Julie
 
Build the string in phases:

strSQL = ...

strSQL = strSQL & ...

strSQL = strSQL & ...
 
Cool, I will try that - Thanks Kingston.


kingston via AccessMonster.com said:
Build the string in phases:

strSQL = ...

strSQL = strSQL & ...

strSQL = strSQL & ...
Click to expand...
 
Back
Top