Well, it's not the prettiest thing in the world, but it definitely
works. Brilliant!
Many thanks for your help,
-Mike Ashmore
On Jan 23, 2006, at 1:01 PM, Kurt Welgehausen wrote:
Sorry, I didn't read your code carefully enough the first time.
Your approach won't work because origin has no explicit type,
and SQLite will not infer a type from the literal string; the
unknown type defaults to numeric.
As Dennis said, the problem is really with RoR, but you can
work around it by creating two 1-row, 1-column tables. Here's
the idea; this is more or less the A part of your view, so
you'll have to add the union and the B part.
sqlite> pragma table_info(t1);
cid name type notnull dflt_value pk
---------- ---------- ---------- ---------- ---------- ----------
0 a integer 0 <> 1
1 c char 0 <> 0
sqlite> create temp table originA (a char);
sqlite> insert into originA values ('a');
sqlite> create temp view va as select t1.*, originA.a origin from
t1, originA;
sqlite> pragma table_info(va);
cid name type notnull dflt_value pk
---------- ---------- ---------- ---------- ---------- ----------
0 a integer 0 <> 0
1 c char 0 <> 0
2 origin char 0 <> 0
Regards
