Here's a way to go with pure SQL;
create table cars (recid,qty,make,model,year,engine,color,state,price);
create table states (abbr,name);
insert into states values(ca,California);
insert into cars values(1,5,Ford,Bandit,2005,2000,Red,ca,5000);
select make,(select name from states where
. If you are constantly
referring to California, make a VIEW just for that query.
JS
-Original Message-
From: Firman Wandayandi [mailto:[EMAIL PROTECTED]
Sent: Sunday, 25 September, 2005 11:43 PM
To: sqlite-users@sqlite.org; [EMAIL PROTECTED]
Subject: Re: [sqlite] Data Manipulation ?
On 9
Richard,
If you need any help I'm available under contract. I'll be in L.A.
next week on business with a client, but otherwise I will be free.
I've been programming for 10+ years and what you need done is very
simple and I could charge for a minimum number of hours and you will
have a full
On 9/26/05, Richard Nagle [EMAIL PROTECTED] wrote:
Does SQLite support any direct built-in commands, that can
manipulate data?
ie.
suppose the boss wanted a report of cars honda in CA,
but he wants to see the California instead of CA,
so you need to convert all the state fields into full