I have tried out both methods in the FireFox extension SQLite Manager
and neither appears to work. Perhaps it is just FireFox parsing the
special character?
Greg
--
You can use the hex code of the non-printable character:
update tableA set field1 = "line1 x'0a' line2"
-Toby
>A
Are there any docs for how to write SQL for special characters like
return and linefeed?
On some systems (eg. http://www.wilsonmar.com/1eschars.htm) return is
\n so an SQL might be something like:
UPDATE TableA SET Field1 = "line 1\nline 2"
which would produce:
line 1
line 2
in Field1
Is ther
Is it possible with just an SQL to Concatenate the content from
several records of a single field with perhaps a character inbetween?
For example if I have TableA that has Field1 with the following info in Field1:
rec1: How
rec2: are
rec3: you
rec4: ?
Would it be possibly using only SQL to o
, 23 Feb 2009 20:35:41 -0500
From: "Igor Tandetnik"
Subject: Re: [sqlite] UPDATE Field based on matching value in
different Table
To: sqlite-users@sqlite.org
Message-ID:
"Greg Robertson"
wrote in message
news:151e70a00902231728j608612b8n491e84b11c70c...@mail.gma
ld4 from tableB
>where TableA.Field3=TableB.Field4 );
>
> Regards,
> Donald
>
> -Original Message-
> From: sqlite-users-boun...@sqlite.org
> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Greg Robertson
> Sent: Monday, February 23, 2009 6:34 PM
> To:
I have two tables each with two fields:
TableA: Field1, Field2
TableB: Field3, Field4
I would like to set Field2 in TableA to the value in Field4 in TableB
where TableA.Field3=TableB.Field4
Sounds simple enough but I can't figure out how to write the UPDATE
SQLite for this.
Can someone help?
I would like to do a date search to find records that are between two
dates. The dates are stored in the table in the format DD-MM- but
I can change that to another format but I prefer something readable
rather than an int or double.
Could someone point me to some docs that could help me write
7 matches
Mail list logo
