Srijit Saha
03/18/2023, 12:47 PMhfhbd
03/18/2023, 12:50 PMSrijit Saha
03/18/2023, 12:51 PMSrijit Saha
03/18/2023, 12:52 PMhfhbd
03/18/2023, 12:53 PMSrijit Saha
03/18/2023, 12:55 PMinsert:
INSERT OR REPLACE INTO transactions (transactionAmount, partyName, isExpendeiture)
VALUES ?;
this is all i got because it doesn't generate anythinghfhbd
03/18/2023, 1:03 PMSrijit Saha
03/18/2023, 1:04 PMCREATE TABLE IF NOT EXISTS transactions (
transactionId INTEGER PRIMARY KEY ASC ,
transactionAmount TEXT,
partyName TEXT,
isExpendeiture INTEGER DEFAULT 0 NOT NULL
);
insert:
INSERT OR REPLACE INTO transactions (transactionAmount, partyName, isExpendeiture)
VALUES ?;
selectAll:
SELECT * FROM transactions;
--
-- selectParticular:
-- SELECT * FROM Transactions WHERE transactionId == ?;
--
-- deleteAll:
-- DELETE FROM Transactions;
hfhbd
03/18/2023, 1:09 PMSrijit Saha
03/18/2023, 1:10 PMSrijit Saha
03/18/2023, 1:10 PMputInValue:
INSERT OR REPLACE INTO transactions (transactionAmount, partyName, isExpendeiture)
VALUES ?;
hfhbd
03/18/2023, 1:19 PMSrijit Saha
03/18/2023, 1:41 PM