>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