>>Craig,
>>
>>>That's my point. I don't have to worry about the RI builder doing this. The default VFP RI code is not very robust and in a big systems can surpase the 64K limitation.
>>
>>I don't experience any problems with the RI code generated by the RI builder. What about this 64K limit ? Do you mean that the stored procedure code cannot exceed the 64K ? I didn't know this.... Are you sure ?
>>

>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.

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,