Max Length of SQL string in BDE/LocalSQL ?

What is the maximum length of a SQL string when using the BDE/LocalSQL on foxpro tables?

Thanks,
joe
LVL 2
greendotAsked:
Who is Participating?
 
dwwangConnect With a Mentor Commented:
Seems there's no one can do the trick.
0
 
dwwangCommented:
A query's SQL property is a TStrings object, so it has the limitation of TStrings. As my test result, it must be less than 32K. Sometimes we have hundres of SQL to execute, then we break them up to 2-3 parts to avoid error.
0
 
greendotAuthor Commented:
dwwang, I only rejected your answer to see if anybody knows if it is possible to break the 32k size limit.  If nobody knows how then I'll give you the points.

Thanks,
joe
0
 
dwwangCommented:
No problem, I'm also eager to know whether one can break the limit. ^_^
0
 
greendotAuthor Commented:
Yep, seems that way.

(sigh)

See in in another question..  :)

-j
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.