>Craig,
>
>>>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* the 64K limit applies to procedures only (and not the whole stored proc file) you won't run into this problem because each procedure within the RI mechanism certainly would stay under the 64K limit, no matter how many tables within your database. The RI mechanism is build up out of at least one proc for each relation. These procedures are rather small and I can't see any circumstances where it might grow out of the 64K limit.
>
>Walter,
The 64K limit is for all Stored Procedures combined. You
WILL hit this limitation on a large system.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer