Using a SQL VIEW with Infopath

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AlexW - 02 Feb 2007 16:15 GMT

I have an infopath form that pulls fields from 6 tables and then submits data
back to some of the tables. Following a suggestion on this forum, I had a
VIEW created to speed up the process, which works great. However, now I
cannot SUBMIT the form: the setup has this message - "Submit Status not
allowed - a SQL Join
statement was used." I'm told by one SQL consultant that Infopath might
require a specific syntax. Can anyone advise me on the correct syntax for
creating the View? Can Infopath SUBMIT back to the tables via a view?

Signature

CNIB
vision help. vision hope

Reply to this Message

Art - 02 Feb 2007 20:57 GMT

A view is generally one way - pulling data from multiple tables

You would need to send the data back to the 6 original tables. But that can
be slow

Unless you create a third table would then replicate back to the original six.

No best solution here.

Does the update back need to be real time or can you store the data and run
updates at night?

> I have an infopath form that pulls fields from 6 tables and then submits data
> back to some of the tables. Following a suggestion on this forum, I had a
[quoted text clipped - 4 lines]
> require a specific syntax. Can anyone advise me on the correct syntax for
> creating the View? Can Infopath SUBMIT back to the tables via a view?

Reply to this Message

AlexW - 03 Feb 2007 12:58 GMT

Thanks for the tip Art. A temporary table with an overnight update would work
for this. Alex.

Signature

CNIB
vision help. vision hope

> A view is generally one way - pulling data from multiple tables
>
[quoted text clipped - 16 lines]
> > require a specific syntax. Can anyone advise me on the correct syntax for
> > creating the View? Can Infopath SUBMIT back to the tables via a view?

Reply to this Message