Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Never ending question
Message
From
16/02/2012 12:28:28
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01535072
Message ID:
01535577
Views:
76
<snip>
>>It is true that this tool does not have the usage of a .Net. However with over 100,000 developers worldwide and a new release every year, for at least the last 6 years, and costing about Euro1000 these guys are making some serious money even if only 10% choose to purchase the upgrades. I suspect many developers will also buy multiple platforms for desktop or mobile or web development.
>>
>>The cool thing about WinDev, for me, is that moving from VFP is simply incredibly easy. You develop projects in the same way; design tables (using visual design tools to create the database and links between files and the business rules), design form layouts using WYSIWYG like VFP form designer (same for reports), connect fields to controls, write code for events and add methods. The language comes with an internal database surpassing VFP's own database in all respects (plus connectivity to any other database) and has memo fields even. The language itself is very similar to VFP with many functions and commands which are virtually identical, for example;
>>
>>
>>SEEK()  ->  HSEEK()
>>FOUND()  ->  HFOUND()
>>DO WHILE ... ENDDO  ->  WHILE ... END
>>FOR ... NEXT  ->  FOR ... END
>>DO CASE ... CASE ... ENDCASE  ->  SWITCH ... CASE ...END
>>
>>
>>I can create forms, functions, program files, etc. almost one for one from an existing VFP application. Copy / paste the VFP code into the WinDev editor and then inline edit the VFP code to convert it to WinDev code. Of course, many things are far easier in WinDev and hence you make make use of features you didn't have before to make the new code better. Also, WinDev handles many things for you.
>>
>>Plus, WinDev can combine multiple languages with its own so if you have PHP or .Net code or C code, etc. you can call that code from within a WinDev app directly. You can even create .Net components with WinDev.
>>
>>It's not perfect, nothing is. It doesn't have millions of users or hundreds of websites and forums dedicated to it. It is a French product and hence documentation and help needs to be translated to English before I can use it. It has its own bugs and one has to find some ways around them. But coming from a VFP background this must be one the lowest learning curve transitions of any language I have seen and very open ended for databases or integration with other languages.
>
>Jos,
>
>PMFJI, I was wondering, does WinDev have a concept similar to VFP cursor? That is, when you retrieve a "recordset" from, say, SQL server, how do you "manipulate" this data? Is it like Dataset in .NET or more like cursor in VFP?

Where you retrieve a record set from SQL you get a view or a query. Same idea as in VFP. The resulting view/query can be connected to a table on a form, into a report or further processed in code.

You don't have a memory cursor like VFP's CREATE CURSOR. But you have the equivalent ability to create a table, with indexes, memo fields, etc. but that always has a disk presence (in a location of your choice). You must then remember to delete the temporary file when you are done with it, as opposed to VFP which automatically closes a cursor and removes any disk files. Otherwise it is the exact same idea.
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform