>><snip>
>>>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.
>>
>
>Can you index such a view or query (for faster processing)? Can you "scan" it and change the values (similar to WHILE or SCAN in VFP)?
>
>>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.
>
>This sounds good. Deleting the temporary file should not be a big issue.
>
>Thank you for your reply.
Short answer is yes to your questions. Long answer and more detail in the links below. Note that WinDev calls its own internal database "HyperFileSQL". They do this to differentiate it between other databases. Also, HyperFileSQL can be implemented for an application in 2 ways; (1) stand-alone, which is just like using DBFs, or (2) in client-server mode where the database resides on a server and data is requested from it by the client application.
Views -
http://doc.windev.com/en-US/?3044248&name=hyperfilesql-viewsQuery -
http://doc.windev.com/en-US/?2032052&name=query
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.