Can not Insert Null Value When I save

Author	Message
Terry Bottorff	Terry Bottorff posted 15 Years Ago Topic Details Share Topic
Group: Forum Members Posts: 448, Visits: 12K	Cannot insert the value NULL into column 'swst_pk', table 'ProRodeo.dbo.SWStocks'; column does not allow nulls. INSERT fails. The statement has been terminated. I get the above error when I try the following code? SwStockBO1.NewRow() SwStockBO1.swst_pk = 1 SwStockBO1.stock = 1000 ' Save New Record If SwStockBO1.Save() <> MicroFour.StrataFrame.Data.SaveUndoResult.Success Then MsgBox("Save New Record Failed") End If I'm a newbie so what am I missing? TIA.
	Reply Like 0

Merge into selected topic...

Merge into merge target...

Merge into a specific topic ID...

Terry Bottorff - 15 Years Ago

PS. The table has only 2 fields. swst_pk, and stock. Both are integer...

Terry Bottorff - 15 Years Ago

[quote][b]Terry Bottorff (01/31/2009)[/b][hr]Cannot insert the value...

Marcia G Akins - 15 Years Ago

Yes swst_pk is my primary key. The reason I don't have it as an...

Terry Bottorff - 15 Years Ago

The same error that I reported previous.

Terry Bottorff - 15 Years Ago

Hi Terry, If you want to manage your own PK updates you have to set...

Edhy Rijo - 15 Years Ago

Hi Terry, Just a comment re 'not wanting the PK to get bigger and...

Peter Jones - 15 Years Ago

Terry, the reason that you are getting the error is answered in Edhy's...

Trent L. Taylor - 15 Years Ago

That was it. Thank you very very much. The help here is excellant.:)

Terry Bottorff - 15 Years Ago

Login
Remember Me Reset Password Resend Validation Email Login