NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: Devan on December 06, 2011, 07:09:39 AM

Title: MS-SQL Autoincrementing not working in NT6? Or is it me?
Post by: Devan on December 06, 2011, 07:09:39 AM

Hi all,

Just started a small, simple WebApp from scratch using NT6.

Got a simple OrderHeader table, with an autoincrementing ID, and a child OrderLines table (which also contains an autoinc ID).

When I generate a form in NT6 to add a new OrderHeader, it is telling me that OHD:ID cannot be blank or zero - I am not getting a number generated, it looks like.

I think I have activated all the server side stuff:

In the Table Properties, the 'Driver Options' is /AUTOINC=SCOPE_IDENTITY()
Under 'Options' I have 'EmulateAutoNumKey' set to 1

In the Field options for ID, I have:
AutoNumber set to '1,1'
IsIdentity set to 1
ServerAutoIncColumn set to 1

In the SQL database, I have the 'Identity' field set to 1.

Anything I have to do within NT6 itself to get the auto numbering to work as it should?

Thanks!

Title: Re: MS-SQL Autoincrementing not working in NT6? Or is it me?
Post by: Bruce on December 06, 2011, 09:07:32 PM

OHD:ID should be a display field on your form (or not there at all), not an Entry field.

cheers
Bruce

Title: Re: MS-SQL Autoincrementing not working in NT6? Or is it me?
Post by: Devan on December 06, 2011, 10:16:52 PM

It was a read only field.  I've even removed it entirely from the form, but the message is still coming up?!?

I even went to the Data Dictionary, and in the 'External Name' of the field put in 'ID | READONLY' but it doesn't seem to make a difference?