>Two of the much asked wish items for vfp8 were:
>
>- Com debugging ability (allmost impossible to do serious com development without this, by the way I recently saw a demo version of Microfocus Cobol and to my surprise you can build Com servers and debug them in the IDE as well !!!)

No

>- Change the code while in the debugger without stopping the program (you can do this in VB since a long time)

No

>
>Are these in the beta ??
>
>Another long waiting wish item was to use subselects in the SQL INSERT. I read that this has made it into the and will save me lot of time ...

Yes

>
>Another one was SQL Server Integration.
>
>I think full integration with SQL Server is a key matter for the live of VFP ... Is the direction that has been chosen the CursorAdaptor? It is too early of course to judge its functionality but it seems that we still have to pass sqlstatements as strings. What we need on this matter is I think full integration. A way to declare that you are connected to SQL Server and then every query should be directed to SQL
Server :

The cursor adapter can use ODBC or ADO as a data source. When you issue TABLEUPDATE(), for example, it works as you would expect. Full integration with SQL Server, like you are asking, is not in the product.

>
>SET SQLERRORS TO SQLERROR_OBJECT
>SET SQLCONNECTION TO SQL_CONNECTION
>BEGIN TRANSACTION
> SELECT * FROM CUSTOMER INTO CURSOR LOCAL_CURSOR
> UPDATE CUSTOMER SET CUSTOMER_CODE = 122112
> INSERT INTO CUSTOMER ...
> IF SQLERROR_OBJECT.ERROR_CODE # 0
> ROLLBACK
> ENDIF
>END TRANSACTION
>SET SQLCONNECTION TO [LOCAL]
>
>Off cource the error handling could be done via the new
>TRY
>...
>CATCH
>...
>FINALLY
>concept
>
>or directly in the query :
>
>BEGIN TRANSACTION SQLCONNECTION SQL_CONNECTION REUSE
> SELECT * FROM CUSTOMER INTO CURSOR LOCAL_CURSOR SQLCONNECTION SQL_CONNECTION REUSE ERRORS TO SQLERROR_OBJECT
> UPDATE CUSTOMER SET CUSTOMER_CODE = 122112 SQLCONNECTION SQL_CONNECTION REUSE ERRORS TO SQLERROR_OBJECT
>END TRANSACTION SQLCONNECTION SQL_CONNECTION REUSE
>
>some other inhancements would be the ability to get results from stored procedures in variables directly e.t.c.
>
>The target should be VFP = the best (fully intagrated) client for SQL Server
>
>I think we have to open a thread on the new capabilities of VFP, what has been left out and what sjould be done for the new version
>
>Thank You