Ruby is awesome, especially when working with Sqlite...using ActiveRecord. But its I/O is really slow, so propagating a database is not its thing.
dvn On Wed, Dec 14, 2011 at 8:32 PM, Nataraj S Narayan <natara...@gmail.com>wrote: > Hi > > I am also an ex-clipper. I miss the old 'code blocks' days. I think > Ruby comes closest to Clipper with its own code blocks. > > regards > > Nataraj > > On Thu, Dec 15, 2011 at 7:17 AM, Jeff Matthews <j...@xexam.net> wrote: > > > > > > I want to use SQLite in a C# app I am developing. > > > > > > > > My database knowledge drops off around 1996, when I gave up Clipper > > programming. I have since learned a little about some of the new > methods > > used by database gurus. But I remember Clipper like it was yesterday > since > > I did so much of it. > > > > > > > > Here is a short snippet of the logic I recall using back when: > > > > > > > > Select (0) // Provides allocation for a new file handle for opening a > > database > > > > Use Customers // Will open Customers dbf, where in those days, each > table > > was its own file, and thus, we had multiple dbf files in an app to use > > relational data. > > > > Set Index to Phone, LastName // The indexes were also stored in > separate > > files. > > > > Set Order to 2 // This would mean that our seeks would use the LastName > > index's sort order > > > > > > > > seek "MATTHEWS" // Try to find the first instance of search string in > the > > index and move record pointer to the row, or if not found, eof() > > > > > > > > numrecs=0 > > > > if found(); > > > > do while trim(upper(LastName))="MATTHEWS" .and. !eof() > // > > cycle through the records and stop if eof() is hit > > > > delete // delete the entire row > > > > numrecs=numrecs+1 > > > > skip // go to next record > > > > enddo > > > > endif > > > > showMessage(ltrim(str(numrecs,0))+" records deleted.") > > > > > > > > That's it. > > > > > > > > I am not wanting to have to deal with excitingly new ways to do all this, > > such as DataSets or Entities, unless someone says, "But, you must!" or > > "You're crazy not to." > > > > > > > > So, which is the best SQLite download for me to use in C# using the > closest > > syntax and logic flow as set forth above? I am ready to download and > start > > hacking. > > > > > > > > Thanks. > > > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users