-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 FrankLane wrote: > Can I pass parameters to the .read command? Like "select * from test where > data=whatever" and then pass the value of whatever to the .read file > somehow?
No. Doing this is starting the slippery slope of becoming a programming language. There are several approaches to this: - - Generate a file for .read containing what you need - - The shell can also read commands from its standard input so you can have another program generating the commands on the fly piping them into the SQLite shell. - - Pick a programming language and use its bindings to SQLite. If you are new to programming I'd recommend Python but you'll find most scripting languages relatively easy to pick up (eg TCL, Ruby, Perl, PHP). You can also use "legacy" languages like Java, C and C++. - - Pick a programming language and use its generic database adaptor interface (eg ODBC/ADO for Microsoft, JDBC for Java) with a SQLite plugin. This is generally a little harder but lets your code be somewhat database independent. The list of programming languages and their SQLite support is at: http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAksUznUACgkQmOOfHg372QQ+EACgg6D7J/YSuHDfC0V1NyXaVfOi Z0gAoL6Wb1XIj2Iq2ymXixTtwql5KkSF =/lYZ -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
