// The cmd string direct output to result
// Execute the command, then open result and read
#include <stdlib.h>
#include <string.h>
#include <stdio.h>
void main() {
FILE *f;
char buff[100];
const char * query = "select 'hello Sqlite3';";
const char * cmd = "sqlite3 test.db < name > result";
f = fopen("name", "w+");
if(f==0) exit(1);
fwrite(query, strlen(query), 1, f);
fclose(f);
f = fopen("result", "r");
if(f==0) exit(2);
system(cmd);
while (fgets(buff, sizeof(buff)-1, f) != NULL)
printf("%s", buff);
fclose(f);
exit(0);
}
On Sun, Jan 29, 2012 at 4:08 PM, Chris Peachment <ch...@ononbb.com> wrote:
> The select statement needs an 's' on 'motorcycle'
> to match the table definition. Or you can remove
> the 's' in the create statement.
>
> On Sun, 2012-01-29 at 20:03 -0400, Chris Peachment wrote:
> > SqlText = "select description from motorcycle "
> > " where model like :model";
> >
>
> _______________________________________________
> 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
