>>Hi All,
>>
>>Can anybody explain why CURSORGETPROP("ConnectHandle") returns different values in VFP6 and VFP9?
>>
>>I have a production system running VFP6 and SQL Server via local views. I am moving this to vfp9 but for some reason CURSORGETPROP("ConnectHandle") returns a different value. In vfp6 it returns a static value irrespective of which table view you have selected, however in VFP9 every time you select a new table view CURSORGETPROP("ConnectHandle") returns a different value.
>>
>>This doesnt mean its wrong I just dont currently understand why so if anybody can give me some pointers it would be greatly appreciated.
>>
>>Thanks
>>
>>Jon
>
>In VFP6 you have a shared connection view, in VFP9 don't, and the VFP alloacate a new connection for every view

Thank you both.