I'm making good headway with the conversion from the use of strings into a normalized database. With the kind help of everyone on the list, I can retrieve the data from the new structure.
I am now at the stage of saving the data to the new structure. Each time I do an update, I need to update multiple rows in the TeamPersonTable with a new orderId and TeamId. I looked up the SQLite documentation and found that Insert works on multiple rows. Can I update multiple rows with one statement ? Cheers. On 5/24/14, fantasia dosa <fantasia.d...@gmail.com> wrote: > I had the misconception that a View contains stored data - come to > think of it, it would not be practical if the result set was really > large. > > Thank you everyone for giving me a better understanding of what a view > really is about. > > Cheers. > > On 5/24/14, Simon Slavin-3 [via SQLite] > <ml-node+s1065341n75815...@n5.nabble.com> wrote: >> >> >> >> On 23 May 2014, at 7:53pm, Humblebee <fantasia.d...@gmail.com> wrote: >> >>> I have a question: "so every time you run a query against a view, >>> that view's query is run/updated if not cached ". >>> >>> Does this mean that if the View is Temporary, then it's not cached? >>> and for normal views, it's cached? >> >> The data associated with a VIEW are never stored at all. Creating a view >> is >> more like a way of saving a SELECT statement in your database. When you >> use >> a VIEW in a later statement SQL executes the SELECT at that point. So >> the >> command needed to reproduce the view can be stored in your database, or >> it >> can be TEMP, but the data it would produce is not stored. >> >> This is oversimplification since the SELECT itself is never executed, >> SQLite >> just figures out how the results would be used in your later statement, >> but >> you understand what I mean. >> >> Simon. >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> >> >> >> _______________________________________________ >> If you reply to this email, your message will be added to the discussion >> below: >> http://sqlite.1065341.n5.nabble.com/Simple-Select-from-IN-from-a-newbie-tp75751p75815.html >> >> To unsubscribe from Simple Select from IN - from a newbie., visit >> http://sqlite.1065341.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=75751&code=ZmFudGFzaWEuZG9zYUBnbWFpbC5jb218NzU3NTF8MTk4Njk4NTgwNw== > -- View this message in context: http://sqlite.1065341.n5.nabble.com/Simple-Select-from-IN-from-a-newbie-tp75751p75820.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users