Data Connections

Re: RowGuid and SQL2005

dswick — Fri, 19 Feb 2010 16:29:18 GMT

Yes the GUID column in the SQLdb is the primary key. I am an old VB programmer and this has worked fine to let SQL generate the newID but Infopath will not allow me to submit the form when I have not assigned a value to field in the DB that does not allow nulls....

Thanks for your help

Re: RowGuid and SQL2005

Hilary Stoupa — Fri, 19 Feb 2010 16:21:09 GMT

Is your GUID column your primary key in your DB? I was trying to test this, and SQL was quite upset that I wanted to set my GUID column with a calculated default to the PK.

(If you don't want to write code for a GUID, and if you are using IP 2007, you could give qRules a try. GenerateGuid is one of many cool commands.)

RowGuid and SQL2005

dswick — Thu, 18 Feb 2010 23:00:03 GMT

I have a form that links to a SQL2005 DB that I was hoping to use a field defined as a uniqueidentifier and auto populate with the newid() function. This works fine when i am adding fields via the SQL management studio but when I try and submit a form to the table, i recieve the following error:

"Infopath cannot submit the form because it contains validation erros that are not in the current view. Errors ......."

Field or group: pkey (defined as a uniqueidentifier and default value of (newid()))
Error: Only specific pattern allowed

I guess I could generate the newid() value in VB code and somehow push this out when the form is published but it would make things easier if the DB could just handle creating the primary key.

Thanks for your help