// The cmd string direct output to result
// Execute the command, then open result and read
#include
#include
#include
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)
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";
>
I don't usually do other people's homework but
it's Sunday night so why not be generous?
At the terminal command line type:
sqlite3 motorcycles.db
At the resulting sqlite3 command line type:
create table motorcycles (
model text;
description text
);
insert into motorcycles
values
Bruce Steele wrote:
I’m a very new “C” programmer working on a program
< to look up information from a SQLite created data
< base. The data base is made up of information on
< models of Harley Davidson motorcycles. I want to
< do a search of the data base using input from the
< “user”. For
I’m a very new “C” programmer working on a program to look up information from
a SQLite created data base.
The data base is made up of information on models of Harley Davidson
motorcycles. I want to do a search of the data base using input from the
“user”. For instance the user wants to know
5 matches
Mail list logo
