>Hi,
>how is it possible to share the connection of two (or more) remote views.
>I was never a problem to do this, but since updating to VFP8 I have problems with it in application.
>
>See the code with SQL-server Northwind database, the result of the code is, that 2 connections are user instead of 2, though the property "Shareconnection" is set to true on both views.
>
>What could be my mistake ?
>
>Thank you,

Hi Andreas,

All VFP8 command use ODBC statement handles instead of ODBC connection handles. You can use SQLGETPROP(..., "ODBChdbc") to get connection handle. See Enhanced SQL Pass-Through Functionality and Language Improvements in help.