SQL Dummy table in a browse

[Matthew51]

Is it possible to have a browse on your SQL dummy table?  I've tried putting the PROP:SQL statement in every embed point I can think of and I always get no records found.

Or if there's a way to use the template to get the information I want.  Here is an example of one of the SQL statements I want to turn into a browse

Code: [Select]

SELECT CAST(t.Time as DATE), SUM(t.Quan) FROM Inventory.Location as l
JOIN History.ArcTransaction as t on t.LocationID = l.LocationID
WHERE l.LocationID = 78865 AND t.Time BETWEEN DATEADD(YEAR, -1, GETDATE()) AND GETDATE()
GROUP BY CAST(t.Time as DATE)
ORDER BY CAST(t.Time as DATE)


[Ubaidullah]

Hi Matthew,

I was able to do this sometime back by putting PROP:SQL after the call to _SetView. I also recall that I omitted the generated view declaration and made my own.

HTH,

Regards,
Ubaidullah Nubar.