Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 3 of 3 total

Tue, Nov 24 2009 12:27 AM	Permanent Link
Scott Woods	I want to do a simple insert into SQL statement that creates a new record, but I dont want to specify any field values. So for example INSERT INTO Customers And thats it. When I run the above I get an error... I dont want to specify any values as I have an ID field that will be generated automatically. Is there a way to do this?
Tue, Nov 24 2009 2:50 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Scott How about inserting a null to any one of the fields? Roy Lambert [Team Elevate]
Tue, Nov 24 2009 3:24 AM	Permanent Link
Uli Becker	Scott > I dont want to specify any values as I have an ID field that will be generated automatically. Is there a way to do this? insert into MyTable(ID) values (null) should work. Uli