>>Technically I am a million years behind you so I don't understand everything you say. And I have never used SQLLite so I dont know how it is used. But generally you are I are in agreement:
>>- getting data from a remote data (SQL Server) into a "cursor" (what you referrred to as SQLLite).
>
>IMO the "cursor" part is more important than the "cursoradapter" - I want the local store to be on disc (unless specifically sent into memory for speed reasons) and able to SQL with local lookup data persisted from install or previous session.
>The things already offered by Dotnet via ADO.Net IMO Dataset/-table/-row are less to my liking than Datareader, Command, Dataprovider and so on. Todays internet speed and phone capabilities offer the chance to utilize the local SSD and CPU.
>
>>- be able to bind "one record" of this "cursor" to a bunch of controls (text boxes, check boxes, etc).
>>- when user clicks on Update/Save call "TableUpdate()" and the remote data (SQL Server) is updated from the "cursro" (being it SQLLite or dataset or something else).
>
>Much of that functionality is there - but targeting RAM and not disk for those queries to remote data. Which is better for a server process like ASP for web pages, but not necessarily for local apps. SQLite is just the most used one - you have it in your phone by default for your adress book if your phone cost more than 200$ in the last 5 years, you probably have it in your email client unless you use a MS client - it is about everywhere.
>>
>
>>Since I don't use Python and/or Lianja I don't how it relates to this.
>
>Python has SQLite integrated into the language, but offers for programming/things to databind to "cursors" again as memory structures. It also offers a dataadapter abstraction called DBAPI which allows you to change your backend. And the code you see is often nice. Would have been easiest to realize the things I want to scratch there in a way I like and language I'd like to program in.
>
>Lianja already offers local vfp-like cursors (and much more) - but is the new kid on the block, and is closed source from a not-big house. Not that big house siblings are guaranteed to live long and prosper ;-)
>
>Both thrown in as a warning that I would probably not do much grind work, as I am currently fully booked and can not even do much fooling around with Lianja, which already has that - not intended as a sales prop or thread drift, as Mike's intention/preference is clearly stated and fully understandable from his expirience POV.
Thank you very much for detailed reply. I have a long way to climb this mountain.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham