HOW TO ADD ITEMS INTO AN ARRAY THAT ARE IN THE STRUCT BUT NOT IN THE DB TABLE USING GRDB IN IOS-Programming & Server Fault Answers-Computer Programming

Upvote:1

struct PartialQuoteList: Codable, FetchableRecord
{
    let QuoteID: Int64
    var Quote_Number: String
    var Quote_Status: String
    var ContactID: String
    var Inv_ID: Int64?
    var Locked_Bool: String
}
for partial in try PartialQuoteList.fetchAll(db, sql: "SELECT * FROM My_Quotes ORDER BY QuoteID") {
    let fullString = ModelData.get_ContactName_Org(contactID: quotes.ContactID).fullStaring
    let first = ModelData.get_ContactName_Org(contactID: quotes.ContactID).firstName
    let last = ModelData.get_ContactName_Org(contactID: quotes.ContactID).lastName
    let org = ModelData.get_ContactName_Org(contactID: quotes.ContactID).clientOrg
    
    let quoteList = QuoteList(
        QuoteID: partial.QuoteID,
        Quote_Number: partial.Quote_Number,
        Quote_Status: partial.Quote_Status,
        ContactID: partial.ContactID,
        ContactFullName: fullString,
        ContactFirst: first,
        ContactLast: last,
        ContactOrg: org,
        Inv_ID: partial.Inv_ID
        Locked_Bool: partial.Locked_Bool)
    
    theArray.append(quoteList)
}

Gwendal Roué 0 3844

Credit Goes to: stackoverflow.com

HOW TO ADD ITEMS INTO AN ARRAY THAT ARE IN THE STRUCT BUT NOT IN THE DB TABLE USING GRDB IN IOS

Related question with same questions but different answers