Submit Form using NewID()

Last post 07-07-2008 04:02 PM by Hilary Stoupa. 1 replies.

Page 1 of 1 (2 items)
	Sort Posts: Previous Next

07-07-2008 11:55 AM

Artimus
Joined on 07-07-2008
Posts 1

Submit Form using NewID()

Reply Contact

I am new to InfoPath. Although I see great potential, it seems very confusing regarding some issues.

I am trying to insert a new record into an SQL Server 2005 database table. The primary key for the table is a GUID. I have prepopulated the table from the back end. Using the form I have created, I can retrieve the rows no problem. When I try to submit a new record, this is where I run into problems. There is no way to specify the NewID() or set a default value for the primay key field.

Any suggestions? What am I missing?

Thanks.