Problem inserting record with autoincrement field #3783
apostrophesoftware
started this conversation in
General
Replies: 1 comment
-
This issue is stale because it has been open for 365 days with no activity. |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
I am trying to insert a record into a table that has an integer primary key field, the insert fails. I have modified the example code to create the Person table with an Id field as below. If I add the field in DB Broswer everything is fine.
Expected behavior
Insert a new record without having to supply the id
Actual behavior
Exception, Aborted, no further details
Steps to reproduce the problem
modify and run sample code as below
(please make this a SSCCE, if applicable and reasonable)
session << "CREATE TABLE Person (Id INTEGER NOT NULL PRIMARY KEY, Name VARCHAR(30), Address VARCHAR, Age INTEGER(3))", now;
POCO version
1.9.0
Compiler and version
g++ (Raspbian 6.3.0-18+rpi1+deb9u1) 6.3.0 20170516
Copyright (C) 2016 Free Software Foundation, Inc.
This is free software; see the source for copying conditions. There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
Operating system and version
PRETTY_NAME="Raspbian GNU/Linux 9 (stretch)"
NAME="Raspbian GNU/Linux"
VERSION_ID="9"
VERSION="9 (stretch)"
ID=raspbian
ID_LIKE=debian
HOME_URL="http://www.raspbian.org/"
SUPPORT_URL="http://www.raspbian.org/RaspbianForums"
BUG_REPORT_URL="http://www.raspbian.org/RaspbianBugs"
Other relevant information
Beta Was this translation helpful? Give feedback.
All reactions