Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Some news about Etecnologia VFP.compiler ??
Message
From
25/02/2008 15:28:38
 
General information
Forum:
Visual FoxPro
Category:
VFP Compiler for .NET
Miscellaneous
Thread ID:
01295603
Message ID:
01296205
Views:
14
Thanks a lot, Samuel.
I know you are very ocuppied.
Can you talk to us if there will be a DEMO compiler ??
Not a web compiler. I think in a compiler for download ??

>Hi Fernando:
>
>Yes there is a lot of new functionality. Right now we are building several samples showing how to do .NET Things in the VFP Way:
>
>For example:
>Web Services.
>http://etecnologia.net/demos/asp.net/foxweb2/myfoxwebservice.asmx has a Web Service implemented in VFP based in the Northwind database shipped with VFP. It receives a customer ID as "VINET" or "ALFKI" and returns some information.
>
>For example to CALCULATE the numbers of orders of some customer here is the code:
>
>		[System::Web::Services::WebMethod] ;
>		PROCEDURE CalculateOrdersCount as integer
>		TPARAMETERS tcCustomerID as string
>		LOCAL nCount
>		THIS.cTable = "orders"
>		THIS.OpenTable()
>		SELECT (THIS.cAlias)
>		IF SEEK(tcCustomerID,THIS.cAlias)
>			COUNT REST FOR customerid = tcCustomerid TO nCount
>			RETURN nCount
>		ELSE
>			RETURN -1
>		ENDIF
>
>Simple? Sure compared with what you would have to code in C# or VB.
>
>ASP.NET pages
>http://etecnologia.net/demos/asp.net/foxweb2/foxform.aspx, shows an ASP.NET form generated from a VFP Form and dealing with data in the VFP Way.
>
>For this month update here is the highlights there are other bits not included in the following list that could appear if we feel they are ready. Hope that give you some NEWS, NEWS, NEWS, ;-)
>
>1. GATHER, SCATTER implemented See the sample test_scatter_gather.prg
>
>2. Compiler now supports 4 letter abbreviations
>
>
>3. CALCULATE implemented and now you can define your own aggregatable functions as MySum() and MyCount(). There are two samples showing how to define your own aggregatables functions. See the sample test_calculate01.prg
>
>4. DATABASE SUPPORT. There are lots of new commands related to databases. See the samples test_dbcommands_createdatabase01.prg, test_dbcommands_createdatabase02.prg and test_database_functions.prg
>a. COPY PROCEDURES
>b. APPEND PROCEDURES
>c. CREATE DATABASE
>d. CREATE CONNECTION
>e. CREATE TRIGGER
>f. CREATEOFFLINE
>g. DROPOFFLINE
>h. DBGETPROP
>i. DBSETPPROP
>j. DELETE CONNECTION
>k. DELETE DATABASE
>l. DELETE TRIGGER
>m. DELETE VIEW
>n. FREE TABLE
>o. REMOVE TABLE
>p. RENAME CONNECTION
>q. RENAME TABLE
>r. RENAME VIEW
>s. PACK DATABASE
>t. VALIDATE DATABASE
>
>Also several new functions related to databases are now available. Now you can put a connection in the Database with a String to use an ADO.NET source as for example the OLE DB, to have a connection to ADO sources. With this you have now the same code model of SQL Passthrough extended to ADO.NET. In the near future this same ability will be extended beyond ADO.NET.
>
>
>5. ASP.NET.
>We Improved the VFP.Runtime multithreading capabilities, specially the TableLayer64. There are two samples online at:
>http://etecnologia.net/demos/asp.net/foxweb/foxform.aspx
>http://etecnologia.net/demos/asp.net/foxweb2/foxform.aspx
>
>Those samples are coded in VFP and compiled to .NET. The ASP.NET Page was automatically generated from the form_orders.scx form included in the controls demo.
>
>6. SQL Passthrough is getting better with the ability to call stored procedures with parameters and also to receive RecordSets from those stored procedures, just like VFP has done always.
>
>7. More commands and functions.
>APPEND MEMO
>COPY MEMO
>ADATABASES()
>ADBOBJECTS()
>DBC()
>INDBC()
>DBGETPROP()
>DEBSETPROP()
>DBUSED()
>
> Several new commands:
> EXTERNAL: helpful to give the compiler a hand to solve references
>COUNT
>TOTAL
>SUM
>AVERAGE
>
>CALCULATE now supports besides the basic functions (MAX, MIN, SUM, …) VAR_SAMP and STDDEV_SAMP as required by the SQL 2003 Standard. And now you can add your own aggregatable functions. Stay tuned for the samples to appear in the next days for this, hopefully some one will build a sample with COVAR() and CORR().
>
>
>And there is more yet ;-)
>
>>Hey Samuel !!!
>>
>>We are all expecting some news about Etecnologia's VFP.compiler.
>>
>>News on http://etecnologia.net are some older ??
>>What about December'07, January'08 and now February'08 ??
>>
>>I think your are very busy, but ...
>>
>>NEWS !!NEWS !!NEWS !!NEWS !!NEWS !!NEWS !!NEWS !!NEWS !!
>>NEWS !!NEWS !!NEWS !!NEWS !!NEWS !!NEWS !!NEWS !!NEWS !!
>>
>>Thanks.
Previous
Reply
Map
View

Click here to load this message in the networking platform