Topic: SQL INSERT
Hi everyone,
First of all, I like this product.
I'm new to this product and been playing with it for the past couple days as time permit. Now, I've trying to run a simple query where when I click to save new record is not inserting the data to all tables. Is only doing the first insert and not the rest
INSERT INTO "Inventory" ("ItemName","ItemDesc")
VALUES ('{txtItemName}','{txtItemDesc}');
INSERT INTO "InvDetails" ("ItenLocation","QtyStock","DateAdded")
VALUES (last_insert_rowid(),'{txtItemLoc}','{txtQtyStock}','{dtAdded}');
INSERT INTO "InvPictures" ("ItemPic")
VALUES (last_insert_rowid(),'{picItenUp}');
Any advise will be very much appreciated.