Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Have two of my favourites been left out ?
Message
From
04/10/2002 03:56:29
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Have two of my favourites been left out ?
Miscellaneous
Thread ID:
00707681
Message ID:
00707681
Views:
59
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 !!!)
- Change the code while in the debugger without stopping the program (you can do this in VB since a long time)

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 ...

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 :

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
Next
Reply
Map
View

Click here to load this message in the networking platform