the length of SQL string

  • Thread starter Thread starter JIM. H.
  • Start date Start date
J

JIM. H.

Hello,
I am using db.Execute sqlString to run a SQL statement in
a module. My questions are as follows.
1. What is the max number of characters in a table name?
2. Is there any limitation on the length of sqlString if
I use is after db.execute?
3. After executing db.Execute sqlString, I get erro 3134
but in watch window I could not see the values of whole
sqlString, it is truncated. how can I see that?
Thanks,
Jim.
 
JIM. H. said:
Hello,
I am using db.Execute sqlString to run a SQL statement in
a module. My questions are as follows.
1. What is the max number of characters in a table name?
Click to expand...

64. Look in help for "specifications"
2. Is there any limitation on the length of sqlString if
I use is after db.execute?
Click to expand...

64,000 (approx.) see help
3. After executing db.Execute sqlString, I get erro 3134
but in watch window I could not see the values of whole
sqlString, it is truncated. how can I see that?
Click to expand...

Error 3134 = Syntax error in INSERT INTO statement.

Post your code including SQL statement.
 
Also, you might try using
Debug.Print sqlString
in your code while you are testing.

This will print the SQL to the immediate pane. You can copy and paste that into
a QUERY and then try to run the query. You will get a better indicator of the
exact location of the error. Another method is to just type
?sqlString
in the immediate window when your code is paused. That will print the SQL in
the immediate window also.
 
Back
Top