baddogi Posted July 21, 2010 Report Share Posted July 21, 2010 In Creator, I am trying to pull data from a view in SQL. It works in SQL but not in PowerGadgets? I'm just wondering if this is supported? Thanks, Quote Link to comment Share on other sites More sharing options...
JuanC Posted July 22, 2010 Report Share Posted July 22, 2010 It should work as well, if you can please post some sample code of the kind of query you are trying to run. JuanC Quote Link to comment Share on other sites More sharing options...
baddogi Posted July 23, 2010 Author Report Share Posted July 23, 2010 Here is some sample code, it's pulling from a view. When I run it in SQL it returns the correct results but in powergadgets it returns 5000 and some results? SELECT [Ticket Number] ,[status] ,[Company Name] ,[site] ,[summary] ,[detail] FROM [companyname].[dbo].[v_table1] where [status]='assigned' Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.