Ask Your Question

wyomason's profile - activity

2019-09-20 13:53:17 +0100 received badge  Notable Question (source)
2019-09-18 16:20:13 +0100 received badge  Famous Question (source)
2019-09-18 04:17:25 +0100 edited question Base: Duplicating a Record in a database

Base: "Insert Into" "User Parameter" I want to duplicate a record in my database. First I select the record: SELECT "C

2019-09-18 04:15:37 +0100 commented answer Base: Duplicating a Record in a database

I learned of a change I could make to your macro so it works with ANY form I create to use with my database, not just th

2019-09-17 01:24:20 +0100 received badge  Enthusiast
2019-09-16 04:00:46 +0100 marked best answer Base: Duplicating a Record in a database

I want to duplicate a record in my database.

First I select the record:

SELECT "Check", "Check_Amount", "Deposit_Amount" FROM "MyMoney" WHERE "ID" = :Enter_ID_No

This brings up a dialog box where I can enter the primary key (ID) of the record I want to copy.

However, when I create a SQL statement to create a new record from the selected record, LibreOffice balks. It won't accept the WHERE clause.

INSERT INTO "MyMoney" ("Check", "Check_Amount", "Deposit_Amount") SELECT "Check", "Check_Amount", "Deposit_Amount" FROM "MyMoney" WHERE "ID" = :Enter_ID_No

If I manually enter the ID number, this works great, just as expected.

INSERT INTO "MyMoney" ("Check", "Check_Amount", "Deposit_Amount") SELECT "Check", "Check_Amount", "Deposit_Amount" FROM "MyMoney" WHERE "ID" = 9

How can I get around this problem so that I could, for example, select a record from a list, note the ID number, and run the SQL and enter the ID number as a user parameter?

2019-09-16 04:00:46 +0100 received badge  Scholar (source)
2019-09-16 04:00:38 +0100 commented answer Base: Duplicating a Record in a database

I have looked at your DuplicateRecord.odb. This is VERY helpful! Thank you. I will be attempting to incorporate this

2019-09-15 08:26:38 +0100 received badge  Notable Question (source)
2019-09-15 02:54:46 +0100 commented answer Base: Duplicating a Record in a database

It is always hard to know how much detail to include when asking a question. I learned right away that the INSERT comma

2019-09-14 22:17:28 +0100 received badge  Popular Question (source)
2019-09-14 17:30:07 +0100 commented question Base: Duplicating a Record in a database

I am using LibreOffice Version: 6.3.1.2 on a Mac running MacOS 10.14.6. The database is the Firebird embedded.. Thanks.

2019-09-14 04:10:09 +0100 asked a question Base: Duplicating a Record in a database

Base: "Insert Into" "User Parameter" I want to duplicate a record in my database. First I select the record: SELECT "C

2019-09-02 00:15:46 +0100 received badge  Popular Question (source)
2019-08-30 02:33:18 +0100 commented answer Can I have a subform on a form with a Table Control?

The post to which you linked in your answer was very helpful, and solved the problem I was having. Thank you very much!

2019-08-30 02:31:34 +0100 commented answer How to unzip ODB file and edit the content.xml file to fix Firebird bug?

This worked as advertised! Thank you so much for this. I wonder what it will take for the bug to get squashed. Your s

2019-08-29 03:58:09 +0100 asked a question Can I have a subform on a form with a Table Control?

Can I have a subform on a form with a Table Control? When I attempt to do this, I get the following error: The data co

2019-08-17 21:44:37 +0100 commented answer base: query by example

This appears to be exactly what I needed to understand. Thank you.

2019-08-17 17:12:30 +0100 received badge  Popular Question (source)
2019-08-17 04:14:01 +0100 asked a question base: query by example

base: query by example Is there a way in LibreOffice Base to query by example? In other words, perhaps have a form that