About the number of fields inserted

[codthing]

When I want to insert 3 or more fields, an error is reported.

expect

createTable({
    tableName: 'people',
    tableFields: [
        {
            columnName: 'id',
            dataType: 'INTEGER PRIMARY KEY AUTOINCREMENT',
        },
        {
            columnName: 'name',
            dataType: 'varchar',
        }, {
            columnName: 'age',
            dataType: 'int',
        }, {
            columnName: 'sex',
            dataType: 'varchar',
        },
    ],
});

recurrent

create table

const created = await createTable("changjing", {
    id: "varchar(50)",
    htmlUrl: "varchar(100)",
    typeName: "varchar(100)"
});

want insert 3 col or more

const likeData = {
    id: '1-1',
    htmlUrl: 'https://xx.com',
    typeName: 'music'
}

insert data

const inserted = (insertData: any) => {
    insert('changjing', [insertData])
        .then(({ row, rowAffected, insertID, lastQuery }) => {
            console.log('success', row, rowAffected, insertID, lastQuery);
            setLikeState(true)
            setVisible(true)
            setTiptext('success！')
    })
    .catch((e) => console.log('error：', e));
}

inserted(likeData)

error

[codthing]

@ltsharma Delete the data table has no effect, it must change to another data table to work.

[ltsharma]

Hi, there is no such limitations for the number of columns for the table, it should work. Can you make sure the column name you have given while creating & the column names while inserting are same? Because your error shows different column names than you created...

[codthing]

@ltsharma It needs to reinstall the app or modify the table name to work.

[ltsharma]

Will consider as a feature request, thank you for your time 😃