>>And are there "higher level" language constructs like scatter to / gather from name ?

>In VFP I used Scatter to and Gather from to copy a record to memory and back again. In WinDev I accomplish this with HCopyRecord(). See also here for a complete list of function related to HyperFile SQL Management:
>http://doc.windev.com/en-US/?3044156

very nice - function call IMO is cleaner in syntax than expressions, but largely a matter of taste


>>Anything similar to table buffering ?

>Not sure if this is exactly the same but WinDev uses a 2-step approach to editing fields of a record. The fields are edited in what I call memory buffers and then you have to specifically tell it to modify the current record with those changes or to create a new record with those changes - HModify() and HAdd() respectively.

Sounds more like record buffering if done on table or memorizing the list needing an update -
But I was hoping for something like
getting a sublist of possible drivers from remote DB into local cursor
// calls to cursorsetproperty() if not done via cursoradapter with fitting update settings
Editing/Appending/Deleting locally in table buffered mode in cursor,
screen outpu bound to cursor fields showing changes on the selected data
calling tableupdate on the cursor

which has problems on mobile and is only under consideration in Lianja as well - record buffering there as well.

>>Something to abstract data backend access like cursoradapter ?
>I never used CursorAdaptor in VFP so cannot comment. However, you can SQL SELECT a data set from a table(s) and it gives you a result set that can be processed like a table, create a Query from it, create a View, edit it, populate a grid, etc.

Here Lianja will get even further, as you can open other remote datasets via ODBC and set a where-filter in the USE,
if you prefer Non-SQL language. But basically all allow further SQL working on local subresults gathered from possibly differing
remote AND local datastores. Nice again

rest sound well rounded - if Lianja does not work, I will look at it in more detail/practice.

When they describe android apps, they write:
"For the Android applications, the only available database is SQLite. To use a database, a SQLite connection must be declared in the data model editor."
http://doc.windev.com/en-US/?9000123&name=android_application_using_and_sharing_data&q=Android%20application

Does this mean than their Hyperfile/dbf local tables approach is not possible there ?
Have you played with this ?

curious as always

thomas