. 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
,"ca",5000);
select make,(select name from states where abbr=state) as statename from
cars;
Steve
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
rg] On Behalf Of Richard Nagle
Sent: 26 September 2005 04:14
To: sqlite-users@sqlite.org
Subject: [sqlit
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
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
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 names,
how would this be done...
Fields are as follows:
5 matches
Mail list logo