On 15 Dec 2011, at 1:47am, Jeff Matthews wrote: > 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()
That is not how SQL works. After you've opened your database file you probably want something like DELETE FROM Customers WHERE LastName = 'MATTHEWS' That's all it is: just that one line. > 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. For checking your understanding of SQL and making up your database file you want the shell tool for your OS. For building SQL commands into your application I'll leave it up to someone who uses C# which I don't. You can find the shell tool as 'Precompiled Binaries' here: <http://www.sqlite.org/download.html> and documentation for it here: <http://www.sqlite.org/sqlite.html> Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
