def tblPeople
      @headers = %w{PersonID FamilyName GivenNames GivenInitials Suffix Role LastUpdate ModifiedBy}
      sql = []   
      @name_collection.ref_collection.all_authors.each do |a|
        cols = {
          PersonID: a.id,
          FamilyName: (a.last_name.length > 0 ? a.last_name : "Unknown"),
          GivenNames: a.first_name || @empty_quotes,
          GivenInitials: a.initials_string || @empty_quotes,
          Suffix: a.suffix || @empty_quotes,
          Role: 1,                          # authors 
          LastUpdate: @time,
          ModifiedBy: @authorized_user_id
        }
        sql << sql_insert_statement('tblPeople', cols) 
      end
      sql.join("\n")
    end
def tblPeople
      @headers = %w{PersonID FamilyName GivenNames GivenInitials Suffix Role LastUpdate ModifiedBy}
      sql = []   
      @name_collection.ref_collection.all_authors.each do |a|
        cols = {
          PersonID: a.id,
          FamilyName: (a.last_name.length > 0 ? a.last_name : "Unknown"),
          GivenNames: a.first_name || @empty_quotes,
          GivenInitials: a.initials_string || @empty_quotes,
          Suffix: a.suffix || @empty_quotes,
          Role: 1,                          # authors 
          LastUpdate: @time,
          ModifiedBy: @authorized_user_id
        }
        sql << sql_insert_statement('tblPeople', cols) 
      end
      sql.join("\n")
    end
Generate tblPeople string.