query max characters limit
From: Satish (Satish_at_discussions.microsoft.com)
Date: Thu, 28 Oct 2004 09:17:03 -0700
I am trying to access data from a table like
"select col1,col2,col3 from table1 where name in ('A1','A2','A3',..,..,..
If the number of elements in the where clause are more, i get a error
message and it looks like there is some limitation in the number of
characters in the query (with sql server i havent observed any limitation).
When I try to avoid this problem by firing individual queries, performance is
severely impacted. Any suggestions on how to get around this problem?
I am using VFP6 and fire these queries through VFP ODBC driver from my VC++
Thanks a lot for your time & support,
-- Satish Invensys