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