I am trying to use a SQL Server view (not a table) to provide a denormalized (joined) dataset to an InfoPath form via a smartObject, but the SQL Service doesn't seem to see views, only tables. Any ideas about how to get around this?
Thanks,
-alex
I am trying to use a SQL Server view (not a table) to provide a denormalized (joined) dataset to an InfoPath form via a smartObject, but the SQL Service doesn't seem to see views, only tables. Any ideas about how to get around this?
Thanks,
-alex
Hi Alex,
I've not attempted this with SQL Views, but you could try:
SELECT * INTO YourNewTableName FROM YourExistingViewName
as this will create a table from your view.
If you want, you can get SQL Server Agent to run a job to recreate this table every hour or something with a TSQL statement like:
use YOURDB
truncate table YourNewTableName
SELECT * INTO YourNewTableName FROM YourExistingViewName
if your view is dynamic, replace the truncate with a drop.
HTH
Martin
Martin,
Thanks, but unfortunately I need this to work in real-time. I guess I could create a table instead of the view and drive it from triggers, but that's really ugly and unmaintainable.
I wonder if K2 is coming out with a fix for the SQL Service.
-a
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.