can I run sql shell also on windows CE and windows Mobile? could you please give me little example how to create virual table to file export it and to pc? I can find it. Can I also delete it from file explorer without problems? Many thanks.
On Fri, Jan 24, 2014 at 9:10 AM, Hick Gunter <h...@scigames.at> wrote: > You can fork off a child process, run the sqlite shell in that and pipe > your commands to it. > > Or you could write a CSV virtual table and execute something like "insert > into <csv> select ..." > > -----Ursprüngliche Nachricht----- > Von: Frantisek Cerven [mailto:feri...@gmail.com] > Gesendet: Freitag, 24. Jänner 2014 07:45 > An: sqlite-users@sqlite.org > Betreff: [sqlite] csv export > > Hello, > > I want to ask you if is any way to call sqlite special commands > programatically from c#. > E.g. I need something like this in code not in command line: > > sqlite> .mode csv > sqlite> .output test.csv > sqlite> select * from tbl1; > sqlite> .output stdout > > If not, what is the quicker way to export table programatically? Now I`m > doing it with DbDataReader, but it is slow. > > Ps: There is not any support user forum?? > > Thank you, > Fratnisek > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > -------------------------------------------------------------------------- > Gunter Hick > Software Engineer > Scientific Games International GmbH > Klitschgasse 2 – 4, A - 1130 Vienna, Austria > FN 157284 a, HG Wien > Tel: +43 1 80100 0 > E-Mail: h...@scigames.at > > This e-mail is confidential and may well also be legally privileged. If > you have received it in error, you are on notice as to its status and > accordingly please notify us immediately by reply e-mail and then delete > this message from your system. Please do not copy it or use it for any > purposes, or disclose its contents to any person as to do so could be a > breach of confidence. Thank you for your cooperation. > _______________________________________________ > 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