>
>>Yes. Positive. SPs are limited to the 64K limitation. In a large, complex database you can hit that limitation.
>
>Are we talking about a single procedure or talking about the whole stored proc file. As I read the VFP system capabilities I read that the limit is on a single procedure, not the whole file.
That's a good question, and one I can't answer. If you use the default VFP RI code it is possible to hit the 64K limit.
>
>If so, I don't see much of a problems. If a single procedure gets over the 64K limit somthing is terribly wrong with your choosen program technique.
>
>>
>>>I agree that the RI code is rather slow, Do you think that native RI could be a solution ?
>>
>>In their book,
Effective Techniques for Application Development with Visual FoxPro, Jim Booth and Steve Sawyer discuss this and have new RI code that is MUCH smaller, more efficient, and adds additional RI capabilities.
>
>Hmmm. Sounds interesting.
>
>Walter,
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer