>Hi,
>
>I have come across an issue where when I try to macro expand a string (that contains INSERT command) and the string is over 612 characters I get error. If the string is less than 612, macro works.
>
>Is there a limit? And if there is, if there a way to get around it?
>
>Thank you in advance for any help.
The following quick test works:
x = "0"
FOR i = 1 TO 500
x = x + " + 1"
next
? &x
String length is 2001.
I would say, check the syntax. Or some built-in limitation of the corresponding SQL command.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)