How to retrieve the new primary key? - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

How to retrieve the new primary key?

Message

From

17/07/2003 13:46:52

Stephen Lee
Client Marketing Systems, Inc.
Pismo Beach, California, United States

To

16/07/2003 11:45:05

Cathi Gero
Prenia Software & Consulting Services
Redmond, Washington, United States

General information

Forum:

ASP.NET

Category:

The Mere Mortals .NET Framework

Title:

Re: How to retrieve the new primary key?

Miscellaneous

Thread ID:

00809477

Message ID:

00811176

Views:

24

>The problem is with the CommandBuilder and not MMF. YOu will need to set the default values for each column that is not configured to accept nulls.

I ran some tests with SQL Profiler and found that the generated SQL command contains "iRecVersion = NULL" when RetrieveAutoIncrementPK = true. When RetrieveAutoIncrementPK = false, iRecVersion is not in the SQL command at all.

Stephen Lee

--------------------------------
Too much to code
Too little time
--------------------------------

Click here to load this message in the networking platform