-
The form is designed off the database – at least it reads the data from the DB and displays the data on the form, but I cannot get it to submit to the DB. How do I do that?
-
Hi, David:
These steps were written out with the intent that form will have been designed off the database, in order to use InfoPath's built in submit to SQL or Access functionality. InfoPath does not provide the option to submit to database otherwise, I'm afraid.
-
Hi Hilary,
in you second set of steps, step 10 says: Make sure the data connection is your main data connection.
How do I do that? how do I set up a main data connection to write data to my SQL Server 2008 DB?
The choices I am given when I try to set one up in the data connection wizard under "How do you want to submit your data?" ...
-
Hi,
I am trying to create my first InfoPath form which is using the
UserProfileService and GetUserProfileByName to pull out the user's name and
email address once they open the form.
If I publish from InfoPath to our DEV server, the form works great. If I point
the service at our LIVE server and publish it there, I get the dreaded ...
-
I got it work using the open event to loop in the repeating table.
thanks again!
-
I don't, sorry. I suggest you open a separate thread for that. Good luck.
-
Provided below are code samples written in C# to format an input as per SharePoint DateTime field.
/* -- Format for Date Only Field -- */
private static String ToSPDate(String strDt)
{
if (strDt == String.Empty)
return strDt;
else
return (Convert.ToDateTime(strDt)).ToString("yyyy-MM-dd");
}
/* -- ...
-
Provided below are code samples written in C# to format an input as per SharePoint DateTime field.
/* -- Format for Date Only Field -- */
private static String ToSPDate(String strDt)
{
if (strDt == String.Empty)
return strDt;
else
return (Convert.ToDateTime(strDt)).ToString("yyyy-MM-dd");
}
/* -- ...
-
I am done on that. There is function called substring instead of substr.
Now, I need only addDays function's functionality in 2003.
If someone can help.
-
Thanks to both of you. However, I am using INFOPATH 2003 and do not have "substr", "addDays" functions.
Any work around for me?