Re: Semi-unable to add new records to table--primary key needed?

2019-12-21 Thread Boylan, Ross
>From: Adrian Klaver >Sent: Saturday, December 21, 2019 3:37 PM > This might be easier to figure out if you outline what is going on: Since I seem to have gone on in my responses, let me do one-line answers before the fuller ones. > 1) The purpose of the migration? Primarily to use currently

Re: BigSQL pgc alternative

2019-12-21 Thread Tomas Vondra
On Fri, Dec 20, 2019 at 12:15:06PM -0300, Samuel Teixeira Santos wrote: Hi all. BigSQL still allow to install Postgres and others resources as like a portable install. But today, it's only offer your tool (pgc) for newer Postgresql versions. I would like to install as portable option because i

Re: Semi-unable to add new records to table--primary key needed?

2019-12-21 Thread Adrian Klaver
On 12/21/19 1:41 PM, Boylan, Ross wrote: My mail interface (Outlook on the Web) really can't quote properly, so I'll just do snips. "When you create a new table in Datasheet view, Access automatically creates a primary key for you and assigns it a field name of "ID" and the AutoNumber data ty

Re: Semi-unable to add new records to table--primary key needed?

2019-12-21 Thread Boylan, Ross
My mail interface (Outlook on the Web) really can't quote properly, so I'll just do snips. >"When you create a new table in Datasheet view, Access automatically creates a primary key for you and assigns it a field name of "ID" and the AutoNumber data type." That quote, and the documentation ment

Re: Semi-unable to add new records to table--primary key needed?

2019-12-21 Thread Adrian Klaver
On 12/21/19 12:21 PM, Boylan, Ross wrote: Thank you for the confirmation on the need for a primary key.  I suspected that, since the GUI needs an easy way to refer to a particular row.  I think I saw such a restriction in the Qt documentation on a different project (just to be clear: no Qt i

Re: Semi-unable to add new records to table--primary key needed?

2019-12-21 Thread Boylan, Ross
Thank you for the confirmation on the need for a primary key.  I suspected that, since the GUI needs an easy way to refer to a particular row.  I think I saw such a restriction in the Qt documentation on a different project (just to be clear: no Qt involved in this one--just more evidence this