Andrea Connell wrote: > > I want one row with all answers for an applicant, and I want it to work > for an arbitrary number of rows in tblQuestions or be able to update > itself on an insert or delete. Any ideas? >
If you want each answer in it's own column, I don't think it can be done without dynamically creating the view for each set of questions. If the answers can all be combined into one column you should be able to use the group_concat() function to combine all the answers into a single string with an arbitrary separator string. HTH Dennis Cote _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
