submit to sql - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

submit to sql

Last post 04-15-2018 05:10 AM by Abdul Rahman. 10 replies.
Page 1 of 1 (11 items)
Sort Posts: Previous Next
  • 03-20-2018 11:59 PM

    submit to sql

    Hi, I am new to infopath, programmer for some other application. retrieving data from sql is working. Anybody give me an idea or link where i can learn to submit data to sql in infopath2013? I've trying this for 1 week in online, no help. Thanks,
    AbdulRahman
  • 03-21-2018 09:58 AM In reply to

    In order to submit to SQL without code, you need to create the form from the Database template. To submit with code, not using a data connection, I'd think you'd need the form to be full trust - but if you have a receive data connection, you could probably leverage that & change the command to use a stored proc (for example) - passing in your form values in code.
    Hilary Stoupa

  • 03-28-2018 06:25 AM In reply to

    Thank you Hilary, for the reply. But, my form is 2013 SQL Database form, connection established, and able retrieve data from the table. The Submit is grayed out while making connection and when I try submit, nothing happens. Please inform is there anything else i have to setup to make this Submit button work? I changed compatibility, trust, etc, still no luck. thanks again, from UAE
    AbdulRahman
  • 03-28-2018 09:18 AM In reply to

    Submit may be disabled due to field types or if this is a browser form. Change the compatibility to Filler, and walk through the connection again. https://support.office.com/en-us/article/introduction-to-submitting-form-data-29b2e228-568d-4d97-bebb-8a92fde59c98#bm2 has info on data types.
    Hilary Stoupa

  • 03-29-2018 04:35 AM In reply to

    hi, thanks again. Gone through the link you provided.. I already tried that, but no luck. I am using infopath 2013. i set the compatibilty, then tried to modify the connection. still the submit option is grayed out. Ooops, why microsoft made this complications.
    AbdulRahman
  • 03-29-2018 07:40 AM In reply to

    Your database tables have none of the types that cause Submit to be disabled? Those are the only 2 things I know of that cause this. Form compatibility and data types.
    Hilary Stoupa

  • 04-01-2018 01:06 AM In reply to

    Hi Hilary, My table contains 2 fields, Number (int) Name (nVARCHAR(50) any issues with this?
    AbdulRahman
  • 04-01-2018 01:40 AM In reply to

    Hi Hilary, Waah, now I got submit option. There was no primary key I set for the table. I made number column as primary key, then tried modifying the data connection, now submit option is on my eyes..thanks for the support Let me go on, brb if any more issues, thanks again from UAE
    AbdulRahman
  • 04-02-2018 07:54 AM In reply to

    Oh! Thanks for posting back on this, I hadn't even thought about a missing primary key being the issue.
    Hilary Stoupa

  • 04-15-2018 05:09 AM In reply to

    You are most welcome. thanks a lot for the support..
    AbdulRahman
  • 04-15-2018 05:10 AM In reply to

    And, if there is any option for validating the submit? i need infopath to ask for the password while submitting the form,, is it possible? any reference you have? thanks again
    AbdulRahman
Page 1 of 1 (11 items)
Copyright © 2003-2018 Qdabra Software. All rights reserved.
View our Terms of Use.