How to insert certain table_1 column value in table_2 along with new user input values

Lalremruata Khiangte 21 Reputation points
2021-06-23T03:28:53.58+00:00

I am stuck and request help. I have an Sqlite3 table and code with PyQt5 in PyCharm. I want to insert id's latest row of table_1 into a "import" column in table_2 simultaneously when a button is click to make new record for/in table_2. [Fetch table_1 id's latest row number and insert into "import" column along with name1 and name2 (user input) text value in table_2 when a button is click.]

Table_1: CREATE TABLE "table_1" ( "id" INTEGER UNIQUE, "first_name" TEXT, "last_name" TEXT, PRIMARY KEY("id" AUTOINCREMENT) )

Table_2: CREATE TABLE "table_2" ( "import" INTEGER, "name1" TEXT, "name2" TEXT )

I have google many website but could not find clue/answer to my problem. There are some code to insert value(s) into another table but they missed out on how to insert into along with capturing the txt_name1 & txt_name2 user's input values.

Thanks in advance.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,364 questions
{count} votes

Accepted answer
  1. CarrinWu-MSFT 6,866 Reputation points
    2021-06-23T06:07:10.777+00:00

    Hi @Lalremruata Khiangte ,

    Welcome to Microsoft Q&A!

    As Olaf said, SQLite is not Microsoft product, suggest that post your question in other related forum. And you could find all products that supported on Microsoft Q&A forum from this link.

    Best regards,
    Carrin


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

0 additional answers

Sort by: Most helpful