SQL Parameter Limit?

[sunny456]

I have a user that's trying to pass 67 parameters to a sql stored proc and Foxpro (V6) is giving her an overflow message. Does anyone know the max number of paramters that Foxpro V6 can pass to a SQL sp.

Any ideas on how to get around this limitation?

Thanks in advance

 

[Neil Toulouse]

How are you building up your command that you are sending to SQL Server?

Could it be that you are storing the values to a text string and hitting the 255 character limit?

If so, take a look at:

thread184-405593

which continues with:

thread184-406700

Neil "I like work. It fascinates me. I can sit and look at it for hours..."