These are the names of actual views in this example. Let me rename them: > insert into rules_table values (1, view10); > insert into rules_table values (2, view20); > insert into rules_table values (3, view30); > insert into rules_table values (4, view40);
On Thu, May 12, 2011 at 7:45 AM, Igor Tandetnik <itandet...@mvps.org> wrote: > John <tauru...@gmail.com> wrote: > > I don't see how that helps. Let's say I have table with rules which > > determine from which view to select: > > > > create rules_table > > (condition integer, myview integer); > > > > insert into rules_table values (1,10); > > insert into rules_table values (2,20); > > insert into rules_table values (3,30); > > insert into rules_table values (4,40); > > > > I would use this query to determine which view to use: > > > > select myview > > from rules_table > > where condition = :condition_in; > > I'm not sure I understand. What other tables do you have? How does an > integer 10 (or 20, or 30, or 40) tell you which of these tables to use? > -- > Igor Tandetnik > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- ~John _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
