Lynda,

I've had similar situations.

I first tried passing my values from VFP to SQL by changing my cursor to an XML string, then in TSQL using OPENXML to convert that to a temporary table from which I can use in TSQL like any other SQL table. But the limitation I ran into there was the 8000 character limit on character types which I had to use to pass the XML string in as a parameter.

The solution that I ended up with is I use OPENROWSET in TSQL to get my VFP data values. While this may be repetitive, depending upon your application, it works well and there is no limit to your data size.


>Thanks, that does work for small sets of known value(s) but I need a more generic solution. There will be from 1 to several hundred PKs in the VFP cursor and their values won't be known in advance...


Anthony