-
Thank you Ernesto. I actually recieved paid support from Hilary last friday to figure this out. I thank you for posting though, I will use this as a guide in the future. Doreen
-
I'm simplifying my original question:
How do I map an identity column that is also a primary key in the DAT tool? I want to create the column on first insert, then retain the original value on subsequent resubmits or writes to database.
still having trouble with this.
-
No worries. I figured if I could figure it out from various postings then my answer wouldn't add any value.
-
Answer: I figured this out but due to lack of interest you may delete my post.
-
Desmo,
did you figure this out? I have same question but this thread is so old nobody will likely respond.
-
I didn't know where to post this question. I am using InfoPath 2007 client forms and SharePoint 2007.
I'm retrieving one set of data from SQL database (using DBXL and qRules) to display in a repeating table. I've created 6 different sections (using same repeating table) which are filtered to only display a portion of the ...
-
Answer: http://www.infopathdev.com/forums/p/5491/20587.aspx
-
I have two text fields; field1 and field2, both set to text data type. Their values are filled from SQL query where SQL data type is smalldatetime. field1 arrives formatted like this: 4/30/2001 while field2 arrives like this 2013-05-25T09:05:24.03. In the database they both look like this: 2001-04-30 00:00:00 and ...
-
I am inserting via DBXL into a database that currently has a primary key that is a non-identity key. When I submit a new record where the primary key is duplicated, it should not insert into database and that is correct behavior however in this situation my form is still submitting to SharePoint when it shouldn't. How do ...
-
Solution: In my situation I had 3 text areas I wanted spaces between. I inserteed '&b' without quote before the 2nd and 3rd text to separate them. Found the answer in your forum.http://www.infopathdev.com/forums/p/5181/19859.aspx